*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
-
Created by
Debra Howell, last updated by Joanne Elisa Leary on Oct 28, 2022
1 minute read
| Link | Description |
|---|---|
| Specifying Ranges | specify range of HRIDs |
| srs_marctab record version | getting the correct version of the record in srs_marctab |
| Getting NULL data that is not marked NULL | steps for getting Null data that is not marked Null |
| Capturing diacritics in export results | Method to export query results to show diacritics correctly |
| Parsing out call numbers | How to use the substring function and regular expressions to parse out the LC Class, LC Class Number and First Cutter from call numbers |
| MARC query samples | some samples for writing MARC queries against the Cornell LDP |
| Optimizing Queries | a list of tips from the FOLIO project to optimize queries running against an LDP reporting database |
| Working with Subject Headings | tips for using subject in queries |
| Multiple Fiscal Years - DRAFT | how to ensure your finance-related query can show data for multiple fiscal years |
| Querying array elements from a data blob | The summary by Angela Zoss shows very handy formulas for querying array elements |
| Pattern matching using the "similar to" function | How to use the "similar to" function to find results that match a list of terms |
| Pattern matching with Regular Expressions | This website is a nice tutorial for regular expressions, which can be useful in parsing out text strings and call numbers. |
| Putting marc subfields in the order in which they appear in the record | How to specify the order of marc subfields within a query (such as subject headings) |