Running a SQL Query in the Client

Staff with the proper permissions can run a SQL query in the find tool. 

Open the corresponding find tool for your search (Item Record, Bibliographic Record, Patron Record, etc.), and toggle the search mode to SQL.

sql search mode.JPG

If you have already written a SQL query, paste or type it into the SQL Search Criteria box, and click Search to run the query.

past query.JPG

There are also number of SQL searches saved in the client. To access, select the "Open" drop down menu and choose one of the available SQL options.

Adjust the query as needed, such as changing the assigned branch ID to your branch. Click Search to initiate the query.

adjust.JPG

If you have suggestions for additional SQL queries to save in the find tool, please submit a help ticket by emailing help@ccslib.org