Basic information
mod-search: https://github.com/folio-org/mod-search/blob/master/README.md#instance-search-options
CQL documentation: https://dev.folio.org/faqs/explain-cql/
Operators:
all: matches records where each term appear in the field
any: matches records where any terms appear in the field
adj: matches if all words of the query string exist consecutively in that order, there may be any whitespace and punctuation in between.
= : synonym for “adj”
== : exact match
Booleans
Can combine search terms with AND, OR, NOT
Supports
Truncation with * wildcard
Instance sample queries
Example category | Query | Results |
|---|---|---|
Subjects | subjects == "*--drama" | Matches instances where “drama” appears as a subdivision |
Subjects | subjects == “drama*” | Matches instances where a subject heading begins with drama |
Subjects | subjects == “drama” | Matches instances where “drama” appears anywhere in the subject |
Holdings sample queries
Example category | Query | Results |
|---|---|---|
Suppressed holdings | holdings.discoverySuppress = "true" | Matches instances which have holdings that are suppressed from discovery |
Notes | holdings.notes.note ="This collection has been digitized for on-site access. No publication rights." | Matches instances which have holdings that have a note equal to “This collection has been digitized for on-site access. No publication rights” |
Item sample queries
Example category | Query | Results |
|---|---|---|
Electronic access | item.electronicAccess.publicNote = "table of contents" | Matches instances with any items that have “table of contents” in the public note of the electronic access data |
Electronic access | item.electronicAccess.uri= "*purl.access.gpo*" | Matches instances with any items that have “purl.access.gpo” somewhere in the URI of the electronic access data |
Nesting queries
Example category | Query | Results |
|---|---|---|
Instance subjects and titles | (subjects == "Ontario" OR subjects == "alberta") AND title all "government" | Matches instances about Ontario OR Alberta with a title that contains “government' |
Instance subjects and titles | subjects all "Ontario" AND subjects all "*--Maps." AND title all "government" | Matches instances about Ontario with a subdivision of maps and “government” in the title |
Queries combining record types
Example category | Query | Results |
|---|---|---|
Instance subjects and holdings permanent location | subjects all "Ontario" AND subjects all "*--Maps." AND title all "government" AND holdings.permanentLocationId = "24be4408-fb6f-4a44-9c91-ecd4982d7849" | Matches instances about Ontario with a subdivision of maps and “government” in the title with holdings located in permanent location “UC/HP/JRL/MapCl” |
Holdings permanent location and item status | subjects all "Ontario" AND subjects all "*--Maps." AND title all "government" AND holdings.permanentLocationId = "24be4408-fb6f-4a44-9c91-ecd4982d7849" AND item.status.name = "Missing" | Matches instances about Ontario with a subdivision of maps and “government” in the title with holdings located in permanent location “UC/HP/JRL/MapCl” and missing items |
Suppressed holdings | holdings.discoverySuppress = "true" AND discoverySuppress = "false" | Matches instances that are NOT suppressed but have holdings that ARE suppressed |