*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
| 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 |
| 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 Titlesto 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 |