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