Skip to content

Instantly share code, notes, and snippets.

@rayvoelker

rayvoelker/get_patron_records_by_last_updated_date.sql

Last active October 25, 2016 15:00
Show Gist options
  • Save rayvoelker/e24c39843e8d1c7d73d9ab8536be7292 to your computer and use it in GitHub Desktop.
Save rayvoelker/e24c39843e8d1c7d73d9ab8536be7292 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_patron_records_by_last_updated_date.sql
SELECT
'p' || r.record_num || 'a' as patron_record_num
-- ,*
FROM
sierra_view.record_metadata as r
WHERE
r.record_type_code = 'p'
AND r.campus_code = ''
AND r.deletion_date_gmt is null
-- AND r.record_last_updated_gmt >= '2012-01-01 00:00:00'
ORDER BY
r.record_last_updated_gmt ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment