# INSERT INTO reporter.template_folder (id, parent, owner, create_time, name, shared, share_with) VALUES (2, NULL, 1, '2009-10-01 10:00:01.634927-05', 'Sample Reports', true, 1); | INSERT INTO reporter.template_folder (id, parent, owner, create_time, name, shared, share_with) VALUES (2, NULL, 1, '2009-10-01 10:00:01.634927-05', 'Sample Reports', true, 1); |
INSERT INTO reporter.template (id, owner, create_time, name, description, data, folder) VALUES (1, 1, '2009-10-01 10:04:09.378398-05', 'New Items List', 'List all new items for selected date range and library.', '{"version":2,"core_class":"acp","select":[{"alias":"Title Proper (normalized)","column":{"colname":"title","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-title","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Author (normalized)","column":{"colname":"author","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-author","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Name","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"acp-location-acpl-name","relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f"},{"alias":"Call Number Label","column":{"colname":"label","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-label","relation":"286d7899ae25bee8bdd7dcde49f9e0b7"},{"alias":"Creation Date/Time","column":{"colname":"create_date","transform":"date","transform_label":"Date"},"path":"acp-create_date","relation":"7d74f3b92b19da5e606d737d339a9679"},{"alias":"Publication Year (normalized)","column":{"colname":"pubdate","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-pubdate","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Record ID","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-id","relation":"640e9f1ba83104cf4de312413f51b877"},{"alias":"ISBN","column":{"colname":"isbn","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-isbn","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Short (Policy) Name","column":{"colname":"shortname","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_lib-aou-shortname","relation":"ab9ff91ac334900edb50f0a5a8e3501f"}],"from":{"path":"acp-call_number","table":"asset.copy","alias":"7d74f3b92b19da5e606d737d339a9679","join":{"call_number-ed55d72666ad50c3c4b9652f5627aba0":{"path":"acp-call_number-acn-record","table":"asset.call_number","key":"id","type":"left","alias":"19a58c77dfa7418c489d7591bce37fc6","join":{"record-19a58c77dfa7418c489d7591bce37fc6":{"type":"left","path":"acp-call_number-acn-record-bre-simple_record","table":"biblio.record_entry","key":"id","alias":"7f0e2da56d7bdf7c7434e87c5abaab5c","join":{"id-rmsr-id-7f0e2da56d7bdf7c7434e87c5abaab5c":{"type":"left","path":"acp-call_number-acn-record-bre-simple_record-rmsr","table":"reporter.materialized_simple_record","key":"id","label":"Item -> Call Number/Volume -> Bibliographic Record :: Simple Record Extracts ","alias":"df8d81aecbe6b10702cbd762ac04cac9","idlclass":"rmsr","template_path":"acp-call_number.acn-record.bre-simple_record"}}}}},"circ_lib-7d74f3b92b19da5e606d737d339a9679":{"path":"acp-circ_lib-aou","table":"actor.org_unit","key":"id","label":"Item :: Circulating Library","alias":"ab9ff91ac334900edb50f0a5a8e3501f","idlclass":"aou","template_path":"acp-circ_lib"},"location-7d74f3b92b19da5e606d737d339a9679":{"path":" |