Logical Set Query Reference
Introduction
The ‘Create a Set’ API can be used to create logical sets for Resource Management content types (Bibs, Items, Portfolios, Digital representations, etc.).
The exact syntax which is needed for creating a set using the API can be determined by first creating a set using the UI, running the ‘Retrieve a Set’ API to view the syntax, and then use the provided syntax as a template for creating other similar logical sets using the API. An example and detailed explanation can be found in this blog post.
Examples
A set of Physical Items can be created using criteria from the Bib record, the Holdings record and the Item record. This example shows a search for items using fields from the related Bib record and the location (which is stored under the Holdings record):
ITEM where BIB_MMS (title CONTAIN "history") and HOLDING (holding_Library OUTER_EQUAL "ART")
The syntax begins with the type of set, in this case ITEM. Then it lists the limiting criteria – first the level, followed by triplets of field code, operator, and value.
The next example demonstrates a search for titles which contain either ‘history’ or ‘writing’ in the title:
BIB_MMS where BIB_MMS (title CONTAIN "history" OR title CONTAIN "writing")
Here the two criteria triplets are separated by the Boolean operator ‘or’.