| Query example | Supported operators | Supported values | UI query example | Associated Jira |
|---|
| 1. | Search for users belonging to a specific patron group | = (equal) in != (not equal) not in | List of existing patron groups, ordered alphabetically | (patronGroup in (“Faculty" ,"Staff”)) | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-188 |
|---|
|
|
| 2. | Search for items associated with a specific location | = (equal) in != (not equal) not in | List of existing locations, ordered alphabetically | (effectiveLocation == "Main library") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-188 |
|---|
|
|
| 3. | Search for loans associated with a specific loan type | = (equal) in != (not equal) not in | List of existing locations, ordered alphabetically | (loanPolicy == "Example Loan Policy") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-207 |
|---|
|
|
| 4. | Search for holdings records associated with a given instance | = (equal) in != (not equal) not in | User enters values in the textbox | (instanceId in "c6371474-cf48-4386-962f-64c6e1069c97", "78654f38-2f68-46df-8518-146763450d2d") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-208 |
|---|
|
|
| 5. | Search for requests by requestor Id | = (equal) in != (not equal) not in | User enters values in the textbox | (requesterId=="74aa0bed-02fc-4c1e-a39d-e6d97e910a88") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-208 |
|---|
|
|
| 6. | Search for instances with a given title | = (equal) in != (not equal) not in contains does not contain starts with | User enters values in the textbox | (title == "interesting")
(title contains "interesting")
(title starts with "interesting") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-209 |
|---|
|
|
| 7. | Search for instances with a specific statistical code | = (equal) in != (not equal) not in | List of existing statistical codes | (statisticalCode=="Actions: recat- Catalog as serial") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-187 |
|---|
|
|
| 8. | Search for instances with a nature of content | = (equal) in != (not equal) not in | List of supported nature of content values | (statisticalCode=="Actions: recat- Catalog as serial") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-187 |
|---|
|
|
| 9. | Search for requests with a given queue position | = (equal)
!= (not equal)
> (greater than)
< (less than) | User enters values in the textbox | (position >1) | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-190 |
|---|
|
|
| 10. | Search for users that have status active | = (equal)
!= (not equal) | True, False are available in the dropdown. | (patronGroup in (“Faculty" ,"Staff”)) and (active==true) | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-191 |
|---|
|
|
| 11. | Search requests that have request date in specified request range | = (equal)
!= (not equal)
> (greater than)
< (less than) >= (greater than or equal)
<= (less than or equal) | User selects date from the date component | (request.requestDate>="2022-10-06T04:00:00.000" AND request.requestDate<="2022-12-17T04:59:59.999") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-192 |
|---|
|
|
| 12. | Search for items with a given status | = (equal) in != (not equal) not in | List of supported item statuses, ordered alphabetically | (status in ("Available", "Checked out") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-217 |
|---|
|
|
| 13. | Search for requests with a specific request type | = (equal) in != (not equal) not in | List of supported requests types, ordered alphabetically | (requestType == "Hold") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-217 |
|---|
|
|
| 14. | Search for records that were created in a specified request range | = (equal)
!= (not equal)
> (greater than)
< (less than) >= (greater than or equal)
<= (less than or equal) | User selects date from the date component | ((instance.metadata.updatedDate>="2022-11-29T05:00:00.000" and instance.metadata.updatedDate<="2022-12-30T04:59:59.999") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-189 |
|---|
|
|
| 15. | Search for requests by requester's barcode | = (equal) in != (not equal) not in contains does not contain starts with | User enters values in the textbox | (request.requester.barcode=="74910788) | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-189 |
|---|
|
|
| 16. | Search for requests by item's barcode | = (equal) in != (not equal) not in contains does not contain starts with | User enters values in the textbox | (request.item.barcode =="088995912) | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-189 |
|---|
|
|
| 17. | Search for requests by instance's title | = (equal) in != (not equal) not in contains does not contain starts with | User enters values in the textbox | (request.instance.title starts with "Interesting") | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-189 |
|---|
|
|
| 18. | Search instances (or holdings or item records) with electronic access containing a specific value in URI | = (equal) in != (not equal) not in contains does not contain starts with | User enters values in the textbox | instance.electronicAccess.linkText contains “http://”) | | Jira |
|---|
| server | FOLIO Issue Tracker |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6ccf3fe4-3301-368a-983e-20c466b11a49 |
|---|
| key | UIBULKED-189 |
|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
