Skip to content

Instantly share code, notes, and snippets.

@sandbergja

sandbergja/Add all copies from a certain call number range into a copy bucket

Created May 25, 2017 17:49
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sandbergja/2a9c88643ecd0578e9f45c9498db7619 to your computer and use it in GitHub Desktop.
Save sandbergja/2a9c88643ecd0578e9f45c9498db7619 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Add all copies from a certain call number range into a copy bucket
INSERT INTO container.copy_bucket_item (bucket, target_copy)
SELECT 1644, id FROM asset.copy
WHERE NOT deleted AND call_number IN
(SELECT id FROM asset.call_number WHERE label ~ 'RT(4[1-9]|5[0-9]|6[0-7])(\.|\s).*' AND NOT deleted);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment