Examples of supported queries
| 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”)) | UIBULKED-188 - Getting issue details... STATUS |
| 2. | Search for items associated with a specific location | = (equal) in != (not equal) not in | List of existing locations, ordered alphabetically | (effectiveLocation == "Main library") | UIBULKED-188 - Getting issue details... STATUS |
| 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") | UIBULKED-207 - Getting issue details... STATUS |
| 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") | UIBULKED-208 - Getting issue details... STATUS |
| 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") | UIBULKED-208 - Getting issue details... STATUS |
| 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") | UIBULKED-209 - Getting issue details... STATUS |
| 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") | UIBULKED-187 - Getting issue details... STATUS |
| 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") | UIBULKED-187 - Getting issue details... STATUS |
| 9. | Search for requests with a given queue position | = (equal) != (not equal) > (greater than) < (less than) | User enters values in the textbox | (position >1) | UIBULKED-190 - Getting issue details... STATUS |
| 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) | UIBULKED-191 - Getting issue details... STATUS |
| 11. | Search requests that have request date in specified request range | = (equal) >= (greater 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") | UIBULKED-192 - Getting issue details... STATUS |
| 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") | UIBULKED-217 - Getting issue details... STATUS |
| 13. | Search for requests with a specific request type | = (equal) in != (not equal) not in | List of supported requests types, ordered alphabetically | (requestType == "Hold") | UIBULKED-217 - Getting issue details... STATUS |
| 14. | Search for records that were created in a specified request range | = (equal) >= (greater 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") | UIBULKED-189 - Getting issue details... STATUS |
| 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) | UIBULKED-189 - Getting issue details... STATUS |
| 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) | UIBULKED-189 - Getting issue details... STATUS |
| 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") | UIBULKED-189 - Getting issue details... STATUS |
| 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://”) | UIBULKED-189 - Getting issue details... STATUS |