{"version":4,"doc_url":"","core_class":"acp","select":[{"alias":"Owning Library","field_doc":"","column":{"colname":"shortname","transform":"upper","transform_label":"Upper case"},"path":"acp-circ_lib-aou-
shortname","relation":"ab9ff91ac334900edb50f0a5a8e3501f"},{"alias":"Call Number","field_doc":"","column":{"colname":"label","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-label","relation":"286d7899ae25bee8bdd7dcde49f9e0b7"},{"alias":"Barcode
","field_doc":"","column":{"colnam
e":"barcode","transform":"Bare","transform_label":"Raw Data"},"path":"acp-barcode","relation":"7d74f3b92b19da5e606d737d339a9679"},{"alias":"Author","field_doc":"","column":{"colname":"author","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-author","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Title","field_doc":"","column":{"colname":"title","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-title","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Pub Year","field_doc":"","column":{"colname":"pubdate","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-pubdate","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Creation Date","field_doc":"","column":{"colname":"create_date","transform":"date","transform_label":"Date"},"path":"acp-create_date","relation":"7d74f3b92b19da5e606d737d339a9679"},{"alias":"Copy Status","field_doc":"","column":{"colname":"name","transform":"upper","transform_label":"Upper case"},"path":"acp-status-ccs-name","relation":"9547fadabf916ce4fd3eb232e0902c9c"},{"alias":"Shelving Location","field_doc":"","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"acp-location-acpl-name","relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f"},{"alias":"Last Edit Date/Time","field_doc":"","column":{"colname":"edit_date","transform":"date","transform_label":"Date"},"path":"acp-edit_date","relation":"7d74f3b92b19da5e606d737d339a9679"}],"from":{"path":"acp-notes","table":"asset.copy","label":"Item","alias":"7d74f3b92b19da5e606d737d339a9679","idlclass":"acp","template_path":"acp","join":{"call_number-7d74f3b92b19da5e606d737d339a9679":{"key":"id","path":"acp-call_number-acn-record","table":"asset.call_number","label":"Item :: Call Number/Volume","alias":"286d7899ae25bee8bdd7dcde49f9e0b7","idlclass":"acn","template_path":"acp-call_number","type":"left","join":{"record-286d7899ae25bee8bdd7dcde49f9e0b7":{"type":"left","key":"id","path":"acp-call_number-acn-record-bre-simple_record","table":"biblio.record_entry","alias":"7f0e2da56d7bdf7c7434e87c5abaab5c","join":{"id-rmsr-id-7f0e2da56d7bdf7c7434e87c5abaab5c":{"type":"left","key":"id","path":"acp-call_number-acn-record-bre-simple_record-rmsr","table":"reporter.materialized_simple_record","label":"Item -> Call Number/Volume -> Bibliographic Record :: Simple Record Extracts ","alias":"df8d81aecbe6b10702cbd762ac04cac9","idlclass":"rmsr","template_path":"acp-call_number.acn-record.bre-simple_record"}}}}},"id-circ-target_copy-7d74f3b92b19da5e606d737d339a9679":{"key":"target_copy","type":"left","path":"acp-circulations-circ","table":"action.circulation","label":"Item :: Circulations","alias":"ddeeaf1839fe1496b309babab563fea7","idlclass":"circ","template_path":"acp-circulations"},"circ_lib-7d74f3b92b19da5e606d737d339a9679":{"key":"id","path":"acp-circ_lib-aou","table":"actor.org_unit","label":"Item :: Circulating Library","alias":"ab9ff91ac334900edb50f0a5a8e3501f","idlclass":"aou","template_path":"acp-circ_lib"},"location-7d74f3b92b19da5e606d737d339a9679":{"key":"id","path":"acp-location-acpl","table":"asset.copy_location","label":"Item :: Shelving Location","alias":"c17ecc44e3cd2de457e5c9f1e6e0a26f","idlclass":"acpl","template_path":"acp-location"},"status-7d74f3b92b19da5e606d737d339a9679":{"key":"id","path":"acp-status-ccs","table":"config.copy_status","label":"Item :: Copy Status","alias":"9547fadabf916ce4fd3eb232e0902c9c","idlclass":"ccs","template_path":"acp-status"},"id-acpn-owning_copy-7d74f3b92b19da5e606d737d339a9679":{"key":"owning_copy","type":"left","path":"acp-notes-acpn-owning_copy","table":"asset.copy_note","alias":"41c4a8b828aa669164f579f587bdbb33","join":{"owning_copy-41c4a8b828aa669164f579f587bdbb33":{"type":"left","key":"id","path":"acp-notes-acpn-owning_copy-acp","table":"asset.copy","label":"Item -> Copy Note :: Copy","alias":"06184aeb6afeff8625a13272a2bfc8c8","idlclass":"acp","template_path":"acp-notes.acpn-owning_copy"}}}}},"where":[{"alias":"Is Deleted","field_doc":"","column":{"colname":"deleted","transform":"Bare","transform_label":"Raw Data"},"path":"acp-deleted","relation":"7d74f3b92b19da5e606d737d339a9679","condition":{"=":"f"}},{"alias":"Organizational Unit ID","field_doc":"","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_lib-aou-id","relation":"ab9ff91ac334900edb50f0a5a8e3501f","condition":{"in":"::P1"}},{"alias":"Name","field_doc":"","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"acp-location-acpl-name","relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f","condition":{"in":"::P2"}},{"alias":"id","field_doc":"","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data"},"path":"acp-status-ccs-id","relation":"9547fadabf916ce4fd3eb232e0902c9c","condition":{"in":"::P3"}},{"alias":"Creation Date/Time","field_doc":"","column":{"colname":"create_date","transform":"Bare","transform_label":"Raw Data"},"path":"acp-notes-acpn-owning_copy-acp-create_date","relation":"06184aeb6afeff8625a13272a2bfc8c8","condition":{"<":"::P4"}},{"alias":"Last Edit Date/Time","field_doc":"","column":{"colname":"edit_date","transform":"Bare","transform_label":"Raw Data"},"path":"acp-notes-acpn-owning_copy-acp-edit_date","relation":"06184aeb6afeff8625a13272a2bfc8c8","condition":{"<":"::P5"}}],"having":[{"alias":"Circ ID","field_doc":"","column":{"colname":"id","transform":"count_distinct","transform_label":"Count Distinct"},"path":"acp-circulations-circ-id","relation":"ddeeaf1839fe1496b309babab563fea7","condition":{"<=":"::P0"}}],"order_by":[],"rel_cache":{"7d74f3b92b19da5e606d737d339a9679":{"label":"Item","alias":"7d74f3b92b19da5e606d737d339a9679","path":"acp","reltype":"","idlclass":"acp","table":"asset.copy","fields":{"dis_tab":{"barcode":{"colname":"barcode","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Barcode","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"create_date":{"colname":"create_date","transform":"date","aggregate":null,"params":null,"transform_label":"Date","alias":"Creation Date","datatype":"timestamp","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"edit_date":{"colname":"edit_date","transform":"date","aggregate":"undefined","params":"undefined","transform_label":"Date","alias":"Last Edit Date/Time","join":"","datatype":"timestamp","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{"deleted":{"colname":"deleted","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Is Deleted","datatype":"bool","op":"=","op_label":"Equals","op_value":{"value":"f","label":"False"},"field_doc":""}},"aggfilter_tab":{}}},"order_by":[{"relation":"ab9ff91ac334900edb50f0a5a8e3501f","field":"shortname"},{"relation":"286d7899ae25bee8bdd7dcde49f9e0b7","field":"label"},{"relation":"7d74f3b92b19da5e606d737d339a9679","field":"barcode"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"author"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"title"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"pubdate"},{"relation":"7d74f3b92b19da5e606d737d339a9679","field":"create_date"},{"relation":"9547fadabf916ce4fd3eb232e0902c9c","field":"name"},{"relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f","field":"name"},{"relation":"7d74f3b92b19da5e606d737d339a9679","field":"edit_date"}],"286d7899ae25bee8bdd7dcde49f9e0b7":{"label":"Item :: Call Number/Volume","alias":"286d7899ae25bee8bdd7dcde49f9e0b7","path":"acp-call_number","reltype":"has_a","idlclass":"acn","table":"asset.call_number","fields":{"dis_tab":{"label":{"colname":"label","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Call Number","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{},"aggfilter_tab":{}}},"df8d81aecbe6b10702cbd762ac04cac9":{"label":"Item -> Call Number/Volume -> Bibliographic Record :: Simple Record Extracts ","alias":"df8d81aecbe6b10702cbd762ac04cac9","path":"acp-call_number.acn-record.bre-simple_record","reltype":"might_have","idlclass":"rmsr","table":"reporter.materialized_simple_record","fields":{"dis_tab":{"title":{"colname":"title","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Title","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"author":{"colname":"author","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Author","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"pubdate":{"colname":"pubdate","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Pub Year","datatype":"int","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{},"aggfilter_tab":{}}},"ddeeaf1839fe1496b309babab563fea7":{"label":"Item :: Circulations","alias":"ddeeaf1839fe1496b309babab563fea7","path":"acp-circulations","reltype":"has_many","idlclass":"circ","table":"action.circulation","fields":{"dis_tab":{},"filter_tab":{},"aggfilter_tab":{"id":{"colname":"id","transform":"count_distinct","aggregate":true,"params":null,"transform_label":"Count Distinct","alias":"Circ ID","datatype":"id","op":"<=","op_label":"Less than or equal to","op_value":{},"field_doc":""}}}},"ab9ff91ac334900edb50f0a5a8e3501f":{"label":"Item :: Circulating Library","alias":"ab9ff91ac334900edb50f0a5a8e3501f","path":"acp-circ_lib","reltype":"has_a","idlclass":"aou","table":"actor.org_unit","fields":{"dis_tab":{"shortname":{"colname":"shortname","transform":"upper","aggregate":"undefined","params":"undefined","transform_label":"Upper case","alias":"Owning Library","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{"id":{"colname":"id","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Organizational Unit ID","datatype":"org_unit","op":"in","op_label":"In list","op_value":{},"field_doc":""}},"aggfilter_tab":{}}},"c17ecc44e3cd2de457e5c9f1e6e0a26f":{"label":"Item :: Shelving Location","alias":"c17ecc44e3cd2de457e5c9f1e6e0a26f","path":"acp-location","reltype":"has_a","idlclass":"acpl","table":"asset.copy_location","fields":{"dis_tab":{"name":{"colname":"name","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Shelving Location","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{"name":{"colname":"name","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Name","join":"","datatype":"text","op":"in","op_label":"In list","op_value":{},"field_doc":""}},"aggfilter_tab":{}}},"9547fadabf916ce4fd3eb232e0902c9c":{"label":"Item :: Copy Status","alias":"9547fadabf916ce4fd3eb232e0902c9c","path":"acp-status","reltype":"has_a","idlclass":"ccs","table":"config.copy_status","fields":{"dis_tab":{"name":{"colname":"name","transform":"upper","aggregate":"undefined","params":"undefined","transform_label":"Upper case","alias":"Copy Status","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{"id":{"colname":"id","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"id","join":"","datatype":"id","op":"in","op_label":"In list","op_value":{},"field_doc":""}},"aggfilter_tab":{}}},"06184aeb6afeff8625a13272a2bfc8c8":{"label":"Item -> Copy Note :: Copy","alias":"06184aeb6afeff8625a13272a2bfc8c8","path":"acp-notes.acpn-owning_copy","join":"","reltype":"has_a","idlclass":"acp","table":"asset.copy","fields":{"dis_tab":{},"filter_tab":{"create_date":{"colname":"create_date","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Creation Date/Time","field_doc":"","join":"","datatype":"timestamp","op":"<","op_label":"Before (Date/Time)","op_value":{}},"edit_date":{"colname":"edit_date","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Last Edit Date/Time","field_doc":"","join":"","datatype":"timestamp","op":"<","op_label":"Before (Date/Time)","op_value":{}}},"aggfilter_tab":{}}}}}