- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Some commonly used SQL operators in Voyager Prepackaged Access Reports, with a few usage examples.
The above query does pattern matching on the Link field. An asterisk matches any sequence of zero or more characters.
•Unknown/nonexistent values (NOT zero! NOT blank!)
•Not used for BLOB queries, which return string values; in BLOB queries, use "" to find empty string values
The above query is an example of an LC Class Shelf List. In addition to showing use of "Is Null" it also shows the use of a subquery and the "Between" operator.
Not equal to
The above query excludes closed patterns (PREDICT field value of "S").
The Not operator can also be used (e.g. Not "S")
•In( ) condition
•Reduces need for multiple OR conditions in a SELECT statement
Note that the above query is also an example where we join fields with different names.
•Mid( ) function
•Extracts a substring from a string
•When using Mid() add one (1) to the byte position (MARC standard starts counting from zero, but MS Access begins counting from one).
The above query finds records where the 008/23 - Form of Item - has no value specified:
It also shows using Leader/07 ("BIB_FORMAT")
Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes. Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.
- Article last edited: 21-Jun-2021