Skip to end of metadata
Go to start of metadata

See list of property names in Query Search - Inventory Beta - Metadata Elements

Examples on CQL syntax: 

Query search Search result

id = "f31a36de-fcf8-44f9-87ef-a55d06ad21ae"

give me the instance record where UUID = f31a36de-fcf8-44f9-87ef-a55d06ad21ae
hrid = "in00000009"give me the instance record where the HRID = in00000009 (this number will later be an 11 digit sequence)
source = "folio"give me all instance records where metadata source = FOLIO
contributors =/@name "frank"give me all instance records where contributor = Frank

identifiers =/@value/@identifierTypeId="439bfbae-75bc-4f74-9fc7-b2a2d47ce3ef" "(OCoLC)07574216"

give me all instance records where OCLC number  = (OCoLC)07574216 - result in BugFest environment

series = "cooperative information systems"

give me all instance records where the serie title = Cooperative information systems
publication = "MIT Press"give me all instance records where the publisher = MIT Press
publication = "c2004"give me all instance records where the publication year = c2004
physicalDescriptions = "bände"give me all instance records where the physical description = bände
subjects = "history"give me all instance records where the subject heading = history
instanceFormatIds = "f5e8210f-7640-459b-a71f-552567f92369"give me all instance records where format term = online resource
holdingsRecords.callNumber = "TK5105.88815 . A58 2004 FT MEADE"give me all holdings records where the call number = TK5105.88815 . A58 2004 FT MEADE
holdingsRecords.copyNumber = "C.2"give me all holdings records where the copy number = C.2
holdingsRecords.holdingsStatements = "v.70-84 (1984-1998)"give me all holdings records where the holdings statement  = v.70-84 (1984-1998)
holdingsRecords.notes = "CharlotteTest"give me all holdings records where the holdings notes  = CharlotteTest
item.enumeration = "v.71"give me all item records where the enumeration  = v.71
item.electronicAccess = "table"give me all item records where there in the electronic access elements is matching value  = table
item.notes = "note"give me all item records where the item note  = note




Boolean search within records and across instance/holdings/item:

Query searchSearch result
title = "qwer" and source = "folio"give me all instance records where resource title = qwer AND metadata source = FOLIO
publication = "MIT Press" and holdingsRecords.callNumber = "TK5105.88815 . A58 2004 FT MEADE"foundgive me all instance records where publisher = MIT Press  AND the associated holdings records has holdings level call number = TK5105.88815 . A58 2004 FT MEADE

subjects = "history" or identifiers = "OCoLC" not publication = "2017"

give me all instance records where publisher = MIT Press  AND the resource identifier is starting with OCoLC and does NOT has publication year = 2017
languages="eng" AND item.itemLevelCallNumber="TK5105*"

give me all instance records where language = English AND the associated item records has item level call number starts with TK5105. The query includes wildcard search with an asterix

identifiers =/@value/@identifierTypeId="216b156b-215e-4839-a53e-ade35cb5702a" "10419/192087"give me all instance records where resource identifier type = handle AND resource identifier = 10419/192087
source = "*" not source = "folio"give me all instance records where metadata source is NOT Folio (but: MARC, and other source formats)


Search queries that currently do not seem to work

Query searchExpected search resultActual search resultTested by / on environmentComments















Retrieve UUIDs

For some CQL queries you need the UUID of the value, because you cannot search for the actual term. To do this, you can use the developer tools that are built into your browser. In Chrome, press F12 to open the developer tools and switch to the "network" tab. Clear out any previous data by pressing "clear" and refresh the Folio page. Please note, that you'll first have to open a detail instance record in the third pane. After the page has loaded, you should look in the network data for the record UUID. Select it to see the record data in JSON format. 

getUUIDs.mp4

  • No labels