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 |