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 |
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) |