...
Index Number | Name | Description | Excel File Download by Level | SQL Query Code |
---|---|---|---|---|
CR219 | Olin Library Shelf List Inventory | This query finds shelf list inventory information for Olin Library. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently. | ||
CR219 | Uris Library Shelf List Inventory | This query finds shelf list inventory information for Uris Library. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently. | ||
CR219 | Kroch Asia Collections Shelf List Inventory | This query finds shelf list inventory information for Kroch Asia Collections. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently. | ||
CR208CR219 | Olin Audio Uris Kroch Visual | This query finds DVDs in the Olin libraryitems with the material type "visual" from owning libraries Olin, Uris, and Kroch Library Asia. | CR219_Olin_Uris_Kroch_Visual | |
CR208 | Uris Audio Visual | This query finds DVDs in the Uris library | CR219_Uris_AV | CR219 SQL Query |
CR208 | Kroch Audio Visual | This query finds DVDs in the Kroch library | ||
CR204 | Missing, Lost, Claimed, Returned Items | This query creates a list of missing, lost, and claimed returned items (including equipment) at a given library, and includes item status date, last date and location of check in, and size/pagination. Sorts in call number order. To view results for a particular library, sort your Excel file on the library_name column. To view results for a particular item status (e.g., Missing, Aged to Lost, Lost and Paid), sort your Excel file on the status_name column. | Missing Lost Claimed Returned Excel Download | CR204 |
...