*** 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 Sharon Helen Markus on Mar 11, 2026
3 minute read
| Link | Description |
|---|---|
| Specifying Ranges | specify range of HRIDs |
| 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 |
| Parsing out Thesis call numbers | Use this query to parse out most thesis 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, dates 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) |
| Working with Dates in SQL in the LDP | tips and tricks for using date and time functions in SQL |
| Finding the location of a character within a string | Use the "Position" function to find the first occurrence of a character within a string |
| Convert text date into real date in Excel output | How to convert a date value that comes out as Text in a query to an actual date/time value in Excel |
| Find median value from an ordered list | How to use a PostGres expression to calculate the median value from a list of values (such as publication dates) |
| Best Source for Publisher and Publication Date | Best practices for including the publisher and publication date fields in your report |
| Find carriage returns and line feed characters in call numbers | This SQL finds carriage returns and line feed characters in call numbers, and coverts the call number to the proper format |
| Aggregate multiple values on separate lines in one cell | Aggregate multiple values (like holdings statements, contributors, holdings notes, etc.) and make them display on separate lines within a cell using the chr(10) character |
| Using the Local Schemas on the Cornell LDP | Guidelines for using the Local Schemas on the Cornell LDP (Library Data Platform) reporting database |
| Importing Data into the Local Schema | instructions for using advanced features of Cornell's reporting environments, such as importing data into local schemas in the LDP and connecting to the Voyager Historical reporting database |
| Using the VTEST Voyager Historical Data Snapshot | all about the snapshot of Voyager historical data and getting access to use it |
| Convert scientific notation barcodes on an Excel spreadsheet to Text format | A simple trick to convert barcodes from scientific notation to Text format |
| Adding a row number to your query results | Use the "ROW_NUMBER" function to insert a row number in your query results |
| Using the SPLIT_PART function to parse out text strings | The SPLIT_PART function allows you to split a text string into numbered segments; it is then easier to extract parts of the segments with regular expressions |
| Setting parameter filters to accept multiple values | How to set Parameter filters and Where statements to select multiple values for a single parameter (such as fiscal years) |
| Show Annex items as an aggregated list on each row of an inventory report | How to aggregate Annex items for easier comparison with an inventory list of unit library's items, to check for duplicates |
| Using COLLATE "C" to Sort Call Numbers and Titles | How to use COLLATE "C" in SQL to sort call numbers and titles, and how to combine this with other functions (UNACCENT, UPPER and REPLACE) to improve title sorting |
| Using "UNACCENT" to remove accent marks | How to install the UNACCENT extension (if necessary) and use the function to remove accent marks for sorting purposes |
| Getting Accurate MARC Record Counts in Metadb | How to include the record state of ACTUAL in your MARC queries to ensure accurate record counts |
| Page Numbers Without Tears | How to add page numbers to your list of printed items |