template created on XUL:


 {"version":4,"doc_url":"","core_class":"acp","select":[{"alias":"Copy Circulating Library","field_doc":"","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_lib-aou-name","relation":"ab9ff91ac334900edb50f0a5a8e3501f"},{"alias":"Call Number Owning Library","field_doc":"","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-owning_lib-aou-name","relation":"bdd43e1440a00047b1e66cb9619865c0"},{"alias":"Shelving Location","field_doc":"","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"acp-location-acpl-name","relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f"},{"alias":"Barcode","field_doc":"","column":{"colname":"barcode","transform":"Bare","transform_label":"Raw Data"},"path":"acp-barcode","relation":"7d74f3b92b19da5e606d737d339a9679"},{"alias":"Call Number Label","field_doc":"","column":{"colname":"label","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-label","relation":"286d7899ae25bee8bdd7dcde49f9e0b7"},{"alias":"Author (normalized)","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 Proper (normalized)","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":"ISBN","field_doc":"","column":{"colname":"isbn","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-simple_record-rmsr-isbn","relation":"df8d81aecbe6b10702cbd762ac04cac9"},{"alias":"Active Date/Time","field_doc":"","column":{"colname":"active_date","transform":"date","transform_label":"Date"},"path":"acp-active_date","relation":"7d74f3b92b19da5e606d737d339a9679"},{"alias":"Total Circulation Count","field_doc":"","column":{"colname":"circ_count","transform":"Bare","transform_label":"Raw Data"},"path":"acp-total_circ_count-erfcc-circ_count","relation":"61e399649f46fcc0bd6386f90bfa79a2"}],"from":{"path":"acp-total_circ_count","table":"asset.copy","label":"Item","alias":"7d74f3b92b19da5e606d737d339a9679","idlclass":"acp","template_path":"acp","join":{"call_number-7d74f3b92b19da5e606d737d339a9679":{"key":"id","path":"acp-call_number-acn-owning_lib","table":"asset.call_number","alias":"286d7899ae25bee8bdd7dcde49f9e0b7","join":{"record-19a58c77dfa7418c489d7591bce37fc6":{"key":"id","path":"acp-call_number-acn-record-bre","table":"biblio.record_entry","label":"Item -> Call Number/Volume :: Bib Record","alias":"640e9f1ba83104cf4de312413f51b877","idlclass":"bre","template_path":"acp-call_number.acn-record"},"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"}}},"owning_lib-286d7899ae25bee8bdd7dcde49f9e0b7":{"type":"left","key":"id","path":"acp-call_number-acn-owning_lib-aou","table":"actor.org_unit","label":"Item -> Call Number/Volume :: Owning Library","alias":"bdd43e1440a00047b1e66cb9619865c0","idlclass":"aou","template_path":"acp-call_number.acn-owning_lib"}},"label":"Item :: Call Number/Volume","idlclass":"acn","template_path":"acp-call_number","type":"left"},"location-7d74f3b92b19da5e606d737d339a9679":{"key":"id","path":"acp-location-acpl","table":"asset.copy_location","label":"Item :: Shelving Location","alias":"c17ecc44e3cd2de457e5c9f1e6e0a26f","idlclass":"acpl","template_path":"acp-location"},"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"},"id-erfcc-id-7d74f3b92b19da5e606d737d339a9679":{"key":"id","type":"left","path":"acp-total_circ_count-erfcc","table":"extend_reporter.full_circ_count","label":"Item :: Total Circulations","alias":"61e399649f46fcc0bd6386f90bfa79a2","idlclass":"erfcc","template_path":"acp-total_circ_count"}}},"where":[{"alias":"Circulating Library","field_doc":"Select a library, then click Add.","column":{"colname":"circ_lib","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_lib","relation":"7d74f3b92b19da5e606d737d339a9679","condition":{"in":"::P0"}},{"alias":"Circulation Modifier","field_doc":"","column":{"colname":"circ_modifier","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_modifier","relation":"7d74f3b92b19da5e606d737d339a9679","condition":{"is":null}},{"alias":"Is Deleted","field_doc":"","column":{"colname":"deleted","transform":"Bare","transform_label":"Raw Data"},"path":"acp-deleted","relation":"7d74f3b92b19da5e606d737d339a9679","condition":{"=":"f"}},{"alias":"Record ID","field_doc":"","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data"},"path":"acp-call_number-acn-record-bre-id","relation":"640e9f1ba83104cf4de312413f51b877","condition":{"not in":["-1"]}}],"having":[],"order_by":[],"rel_cache":{"7d74f3b92b19da5e606d737d339a9679":{"label":"Item","alias":"7d74f3b92b19da5e606d737d339a9679","path":"acp","join":"","reltype":"","idlclass":"acp","table":"asset.copy","fields":{"dis_tab":{"barcode":{"colname":"barcode","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Barcode","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"active_date":{"colname":"active_date","transform":"date","aggregate":null,"params":null,"transform_label":"Date","alias":"Active Date/Time","field_doc":"","join":"","datatype":"timestamp","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{"circ_lib":{"colname":"circ_lib","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Circulating Library","join":"","datatype":"org_unit","op":"in","op_label":"In list","op_value":{},"field_doc":"Select a library, then click Add."},"circ_modifier":{"colname":"circ_modifier","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Circulation Modifier","join":"","datatype":"link","op":"is","op_label":"Is NULL","op_value":{},"field_doc":""},"deleted":{"colname":"deleted","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Is Deleted","field_doc":"","join":"","datatype":"bool","op":"=","op_label":"Equals","op_value":{"value":"f","label":"False"}}},"aggfilter_tab":{}}},"order_by":[{"relation":"ab9ff91ac334900edb50f0a5a8e3501f","field":"name"},{"relation":"bdd43e1440a00047b1e66cb9619865c0","field":"name"},{"relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f","field":"name"},{"relation":"7d74f3b92b19da5e606d737d339a9679","field":"barcode"},{"relation":"286d7899ae25bee8bdd7dcde49f9e0b7","field":"label"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"author"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"title"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"isbn"},{"relation":"7d74f3b92b19da5e606d737d339a9679","field":"active_date"},{"relation":"61e399649f46fcc0bd6386f90bfa79a2","field":"circ_count"}],"640e9f1ba83104cf4de312413f51b877":{"label":"Item -> Call Number/Volume :: Bib Record","alias":"640e9f1ba83104cf4de312413f51b877","path":"acp-call_number.acn-record","join":"","reltype":"has_a","idlclass":"bre","table":"biblio.record_entry","fields":{"dis_tab":{},"filter_tab":{"id":{"colname":"id","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Record ID","join":"","datatype":"id","op":"not in","op_label":"Not in list","op_value":{"value":["-1"],"label":"\"-1\""},"field_doc":""}},"aggfilter_tab":{}}},"286d7899ae25bee8bdd7dcde49f9e0b7":{"label":"Item :: Call Number/Volume","alias":"286d7899ae25bee8bdd7dcde49f9e0b7","path":"acp-call_number","join":"","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 Label","join":"","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","join":"","reltype":"might_have","idlclass":"rmsr","table":"reporter.materialized_simple_record","fields":{"dis_tab":{"author":{"colname":"author","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Author (normalized)","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"title":{"colname":"title","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Title Proper (normalized)","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"isbn":{"colname":"isbn","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"ISBN","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{},"aggfilter_tab":{}}},"c17ecc44e3cd2de457e5c9f1e6e0a26f":{"label":"Item :: Shelving Location","alias":"c17ecc44e3cd2de457e5c9f1e6e0a26f","path":"acp-location","join":"","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","field_doc":"","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"ab9ff91ac334900edb50f0a5a8e3501f":{"label":"Item :: Circulating Library","alias":"ab9ff91ac334900edb50f0a5a8e3501f","path":"acp-circ_lib","join":"","reltype":"has_a","idlclass":"aou","table":"actor.org_unit","fields":{"dis_tab":{"name":{"colname":"name","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Copy Circulating Library","field_doc":"","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"bdd43e1440a00047b1e66cb9619865c0":{"label":"Item -> Call Number/Volume :: Owning Library","alias":"bdd43e1440a00047b1e66cb9619865c0","path":"acp-call_number.acn-owning_lib","join":"","reltype":"has_a","idlclass":"aou","table":"actor.org_unit","fields":{"dis_tab":{"name":{"colname":"name","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Call Number Owning Library","field_doc":"","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"61e399649f46fcc0bd6386f90bfa79a2":{"label":"Item :: Total Circulations","alias":"61e399649f46fcc0bd6386f90bfa79a2","path":"acp-total_circ_count","join":"","reltype":"might_have","idlclass":"erfcc","table":"extend_reporter.full_circ_count","fields":{"dis_tab":{"circ_count":{"colname":"circ_count","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Total Circulation Count","field_doc":"","join":"","datatype":"int","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}}}}


Cloned without any editing:


 {"version":5,"doc_url":"","core_class":"acp","select":[{"alias":"Barcode","path":"acp-barcode","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"barcode","transform":"Bare","transform_label":"Raw Data","a
ggregate":false}},{"alias":"Active Date/Time","path":"acp-active_date","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"active_date","transform":"date","transform_label":"Date","aggregate":false}},{"alias
":"Call Number Label","path":"acn-label","field_doc":"","relation":"286d7899ae25bee8bdd7dcde49f9e0b7","column":{"colname":"label","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Author (normalized)","path":"
rmsr-author","field_doc":"","relation":"df8d81aecbe6b10702cbd762ac04cac9","column":{"colname":"author","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Title Proper (normalized)","path":"rmsr-title","field_do
c":"","relation":"df8d81aecbe6b10702cbd762ac04cac9","column":{"colname":"title","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"ISBN","path":"rmsr-isbn","field_doc":"","relation":"df8d81aecbe6b10702cbd762ac0
4cac9","column":{"colname":"isbn","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Shelving Location","path":"acpl-name","field_doc":"","relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f","column":{"colname":"name"
,"transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Copy Circulating Library","path":"aou-name","field_doc":"","relation":"ab9ff91ac334900edb50f0a5a8e3501f","column":{"colname":"name","transform":"Bare","transf
orm_label":"Raw Data","aggregate":false}},{"alias":"Call Number Owning Library","path":"aou-name","field_doc":"","relation":"bdd43e1440a00047b1e66cb9619865c0","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","ag
gregate":false}},{"alias":"Total Circulation Count","path":"erfcc-circ_count","field_doc":"","relation":"61e399649f46fcc0bd6386f90bfa79a2","column":{"colname":"circ_count","transform":"Bare","transform_label":"Raw Data","aggregate":false
}}],"from":{"alias":"7d74f3b92b19da5e606d737d339a9679","path":"acp-acp","table":"asset.copy","idlclass":"acp","label":"Item","join":{"call_number-ed55d72666ad50c3c4b9652f5627aba0":{"type":"inner","key":"id","alias":"286d7899ae25bee8bdd7d
cde49f9e0b7","path":"acp-call_number","table":"asset.call_number","idlclass":"acn","label":"Item :: Call Number/Volume","join":{"record-1735d2b1c8f8641d9a68f4b357ee65d1":{"type":"inner","key":"id","alias":"640e9f1ba83104cf4de312413f51b87
7","path":"acp-call_number-record","table":"biblio.record_entry","idlclass":"bre","join":{"id-simple_record-71106b868faa6f1abfa23de0f072d2df":{"type":"inner","key":"id","alias":"df8d81aecbe6b10702cbd762ac04cac9","path":"acp-call_number-r
ecord-id-simple_record","table":"reporter.materialized_simple_record","idlclass":"rmsr","label":"Item -> Call Number/Volume -> Bibliographic Record :: Simple Record Extracts "}},"label":"Item -> Call Number/Volume :: Bib Record"},"owning
_lib-8ae2598e830aacad13ae04e7dcafeda3":{"type":"inner","key":"id","alias":"bdd43e1440a00047b1e66cb9619865c0","path":"acp-call_number-owning_lib","table":"actor.org_unit","idlclass":"aou","label":"Item -> Call Number/Volume :: Owning Libr
ary"}}},"location-ccdc1d371ff6eeb5e16397677300bf76":{"type":"inner","key":"id","alias":"c17ecc44e3cd2de457e5c9f1e6e0a26f","path":"acp-location","table":"asset.copy_location","idlclass":"acpl","label":"Item :: Shelving Location"},"circ_li
b-eb2d7f1fefe6a54c8f29fd69d7d4f600":{"type":"inner","key":"id","alias":"ab9ff91ac334900edb50f0a5a8e3501f","path":"acp-circ_lib","table":"actor.org_unit","idlclass":"aou","label":"Item :: Circulating Library"},"id-total_circ_count-236b4bb
83c8462f3159c267f6a13d9b9":{"type":"inner","key":"id","alias":"61e399649f46fcc0bd6386f90bfa79a2","path":"acp-id-total_circ_count","table":"extend_reporter.full_circ_count","idlclass":"erfcc","label":"Item :: Total Circulations"}}},"where
":[{"alias":"Circulating Library","path":"acp-circ_lib","field_doc":"Select a library, then click Add.","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"circ_lib","transform":"Bare","transform_label":"Raw Data","aggrega
te":0},"condition":{"in":"::P0"}},{"alias":"Circulation Modifier","path":"acp-circ_modifier","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"circ_modifier","transform":"Bare","transform_label":"Raw Data"
,"aggregate":0},"condition":{"is":null}},{"alias":"Is Deleted","path":"acp-deleted","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"deleted","transform":"Bare","transform_label":"Raw Data","aggregate":0}
,"condition":{"=":"f"}},{"alias":"Record ID","path":"bre-id","field_doc":"","relation":"640e9f1ba83104cf4de312413f51b877","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"not in":["-1"
]}}],"having":[],"display_cols":[{"name":"barcode","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq
","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":0,"label":"Barcode","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item"},{"name":"active
_date","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"a
cp"},"table":"asset.copy"}],"index":1,"label":"Active Date/Time","datatype":"timestamp","doc_text":"","transform":{"label":"Date","transform":"date","aggregate":null},"path_label":"Item"},{"name":"label","path":[{"label":"Item","id":"acp
","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Cal
l Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Ca
ll Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_numbe
r_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"}],"index":2,"label":"Call Number Label","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_l
abel":"Item :: Call Number/Volume"},{"name":"author","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_s
eq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datat
ype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Nu
mber/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Bibliographic Record","from":"acn","link":{"name":"
record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"id":"acn.bre","jtype":"inner","uplink":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"classname":"bre","struct":{"name":"bre","label":"Bibliographic Record","table":"biblio.record_entry","core":true,"pkey":"id","pkey_sequence":"biblio.record_entry_id_seq","core_label":"Core sources","classname":"bre"},"table":"biblio.record_entry"},{"label":"Fast Simple Record Extracts","from":"bre","link":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"id":"bre.rmsr","jtype":"inner","uplink":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"classname":"rmsr","struct":{"name":"rmsr","label":"Fast Simple Record Extracts","table":"reporter.materialized_simple_record","pkey":"id","core_label":"Non-core sources","classname":"rmsr"},"table":"reporter.materialized_simple_record"}],"index":3,"label":"Author (normalized)","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item -> Call Number/Volume -> Bibliographic Record :: Simple Record Extracts "},{"name":"title","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Bibliographic Record","from":"acn","link":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"id":"acn.bre","jtype":"inner","uplink":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"classname":"bre","struct":{"name":"bre","label":"Bibliographic Record","table":"biblio.record_entry","core":true,"pkey":"id","pkey_sequence":"biblio.record_entry_id_seq","core_label":"Core sources","classname":"bre"},"table":"biblio.record_entry"},{"label":"Fast Simple Record Extracts","from":"bre","link":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"id":"bre.rmsr","jtype":"inner","uplink":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"classname":"rmsr","struct":{"name":"rmsr","label":"Fast Simple Record Extracts","table":"reporter.materialized_simple_record","pkey":"id","core_label":"Non-core sources","classname":"rmsr"},"table":"reporter.materialized_simple_record"}],"index":4,"label":"Title Proper (normalized)","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item -> Call Number/Volume -> Bibliographic Record :: Simple Record Extracts "},{"name":"isbn","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Bibliographic Record","from":"acn","link":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"id":"acn.bre","jtype":"inner","uplink":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"classname":"bre","struct":{"name":"bre","label":"Bibliographic Record","table":"biblio.record_entry","core":true,"pkey":"id","pkey_sequence":"biblio.record_entry_id_seq","core_label":"Core sources","classname":"bre"},"table":"biblio.record_entry"},{"label":"Fast Simple Record Extracts","from":"bre","link":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"id":"bre.rmsr","jtype":"inner","uplink":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"classname":"rmsr","struct":{"name":"rmsr","label":"Fast Simple Record Extracts","table":"reporter.materialized_simple_record","pkey":"id","core_label":"Non-core sources","classname":"rmsr"},"table":"reporter.materialized_simple_record"}],"index":5,"label":"ISBN","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item -> Call Number/Volume -> Bibliographic Record :: Simple Record Extracts "},{"name":"name","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Copy/Shelving Location","from":"acp","link":{"name":"location","label":"Shelving Location","type":"link","key":"id","class":"acpl","reltype":"has_a","datatype":"link"},"id":"acp.acpl","jtype":"inner","uplink":{"name":"location","label":"Shelving Location","type":"link","key":"id","class":"acpl","reltype":"has_a","datatype":"link"},"classname":"acpl","struct":{"name":"acpl","label":"Copy/Shelving Location","table":"asset.copy_location","pkey":"id","pkey_sequence":"asset.copy_location_id_seq","core_label":"Non-core sources","classname":"acpl"},"table":"asset.copy_location"}],"index":6,"label":"Shelving Location","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item :: Shelving Location"},{"name":"name","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Organizational Unit","from":"acp","link":{"name":"circ_lib","label":"Circulating Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"id":"acp.aou","jtype":"inner","uplink":{"name":"circ_lib","label":"Circulating Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"classname":"aou","struct":{"name":"aou","label":"Organizational Unit","table":"actor.org_unit","pkey":"id","pkey_sequence":"actor.org_unit_id_seq","core_label":"Non-core sources","classname":"aou"},"table":"actor.org_unit"}],"index":7,"label":"Copy Circulating Library","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item :: Circulating Library"},{"name":"name","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Organizational Unit","from":"acn","link":{"name":"owning_lib","label":"Owning Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"id":"acn.aou","jtype":"inner","uplink":{"name":"owning_lib","label":"Owning Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"classname":"aou","struct":{"name":"aou","label":"Organizational Unit","table":"actor.org_unit","pkey":"id","pkey_sequence":"actor.org_unit_id_seq","core_label":"Non-core sources","classname":"aou"},"table":"actor.org_unit"}],"index":8,"label":"Call Number Owning Library","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item -> Call Number/Volume :: Owning Library"},{"name":"circ_count","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Total Circulation Count, Including Legacy","from":"acp","link":{"name":"total_circ_count","label":"Total Circulations","virtual":true,"type":"link","key":"id","class":"erfcc","reltype":"might_have","datatype":"link"},"id":"acp.erfcc","jtype":"inner","uplink":{"name":"total_circ_count","label":"Total Circulations","virtual":true,"type":"link","key":"id","class":"erfcc","reltype":"might_have","datatype":"link"},"classname":"erfcc","struct":{"name":"erfcc","label":"Total Circulation Count, Including Legacy","table":"extend_reporter.full_circ_count","pkey":"id","core_label":"Non-core sources","classname":"erfcc"},"table":"extend_reporter.full_circ_count"}],"index":9,"label":"Total Circulation Count","datatype":"int","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item :: Total Circulations"}],"filter_cols":[{"name":"circ_lib","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":10,"label":"Circulating Library","datatype":"org_unit","doc_text":"Select a library, then click Add.","operator":{"op":"in","label":"In list"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item"},{"name":"circ_modifier","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":11,"label":"Circulation Modifier","datatype":"link","doc_text":"","operator":{"op":"is","label":"Is NULL"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item"},{"name":"deleted","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":12,"label":"Is Deleted","datatype":"bool","doc_text":"","operator":{"op":"=","label":"Equals"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item","value":"f"},{"name":"id","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Bibliographic Record","from":"acn","link":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"id":"acn.bre","jtype":"inner","uplink":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"classname":"bre","struct":{"name":"bre","label":"Bibliographic Record","table":"biblio.record_entry","core":true,"pkey":"id","pkey_sequence":"biblio.record_entry_id_seq","core_label":"Core sources","classname":"bre"},"table":"biblio.record_entry"}],"index":13,"label":"Record ID","datatype":"id","doc_text":"","operator":{"op":"not in","label":"Not in list"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item -> Call Number/Volume :: Bib Record","value":["-1"]}]}


Cloned with removed then put back all fields from linked tables 


 {"version":5,"doc_url":"","core_class":"acp","select":[{"alias":"Author (normalized)","path":"rmsr-author","field_doc":"","relation":"2e6a9becadec040d1ae1a04253ea1cf5","column":{"colname":"author","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Title Proper (normalized)","path":"rmsr-title","field_doc":"","relation":"2e6a9becadec040d1ae1a04253ea1cf5","column":{"colname":"title","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"ISBN","path":"rmsr-isbn","field_doc":"","relation":"2e6a9becadec040d1ae1a04253ea1cf5","column":{"colname":"isbn","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Call Number Owning Library","path":"aou-name","field_doc":"","relation":"77f74b41c9b9e932dd45e472e82bcfe6","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Total Circulation Count","path":"erfcc-circ_count","field_doc":"","relation":"61e399649f46fcc0bd6386f90bfa79a2","column":{"colname":"circ_count","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Copy Circulating Library","path":"aou-name","field_doc":"","relation":"ab9ff91ac334900edb50f0a5a8e3501f","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Shelving Location","path":"acpl-name","field_doc":"","relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Active Date/Time","path":"acp-active_date","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"active_date","transform":"date","transform_label":"Date","aggregate":false}},{"alias":"Barcode","path":"acp-barcode","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"barcode","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Call Number Label","path":"acn-label","field_doc":"","relation":"4c62b7c3d660433b7e6842f27283892b","column":{"colname":"label","transform":"Bare","transform_label":"Raw Data","aggregate":false}}],"from":{"alias":"7d74f3b92b19da5e606d737d339a9679","path":"acp-acp","table":"asset.copy","idlclass":"acp","join":{"call_number-ed55d72666ad50c3c4b9652f5627aba0":{"type":"inner","key":"id","alias":"4c62b7c3d660433b7e6842f27283892b","path":"acp-call_number","table":"asset.call_number","idlclass":"acn","join":{"record-1735d2b1c8f8641d9a68f4b357ee65d1":{"type":"inner","key":"id","alias":"1735d2b1c8f8641d9a68f4b357ee65d1","path":"acp-call_number-record","table":"biblio.record_entry","idlclass":"bre","join":{"id-simple_record-71106b868faa6f1abfa23de0f072d2df":{"type":"inner","key":"id","alias":"2e6a9becadec040d1ae1a04253ea1cf5","path":"acp-call_number-record-id-simple_record","table":"reporter.materialized_simple_record","idlclass":"rmsr","label":"Item -> Call Number/Volume (inner) -> Bib Record (inner) -> Simple Record Extracts  (inner)"}}},"owning_lib-8ae2598e830aacad13ae04e7dcafeda3":{"type":"inner","key":"id","alias":"77f74b41c9b9e932dd45e472e82bcfe6","path":"acp-call_number-owning_lib","table":"actor.org_unit","idlclass":"aou","label":"Item -> Call Number/Volume (inner) -> Owning Library (inner)"}},"label":"Item -> Call Number/Volume (inner)"},"id-total_circ_count-236b4bb83c8462f3159c267f6a13d9b9":{"type":"inner","key":"id","alias":"61e399649f46fcc0bd6386f90bfa79a2","path":"acp-id-total_circ_count","table":"extend_reporter.full_circ_count","idlclass":"erfcc","label":"Item :: Total Circulations"},"circ_lib-eb2d7f1fefe6a54c8f29fd69d7d4f600":{"type":"inner","key":"id","alias":"ab9ff91ac334900edb50f0a5a8e3501f","path":"acp-circ_lib","table":"actor.org_unit","idlclass":"aou","label":"Item :: Circulating Library"},"location-ccdc1d371ff6eeb5e16397677300bf76":{"type":"inner","key":"id","alias":"c17ecc44e3cd2de457e5c9f1e6e0a26f","path":"acp-location","table":"asset.copy_location","idlclass":"acpl","label":"Item :: Shelving Location"}},"label":"Item"},"where":[{"alias":"Call Number/Volume ID","path":"acn-id","field_doc":"","relation":"4c62b7c3d660433b7e6842f27283892b","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"not in":"-1"}},{"alias":"Circulating Library","path":"acp-circ_lib","field_doc":"Select a library, then click Add.","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"circ_lib","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"in":"::P0"}},{"alias":"Circulation Modifier","path":"acp-circ_modifier","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"circ_modifier","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"is":null}},{"alias":"Is Deleted","path":"acp-deleted","field_doc":"","relation":"7d74f3b92b19da5e606d737d339a9679","column":{"colname":"deleted","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"=":"f"}}],"having":[],"display_cols":[{"name":"author","label":"Author (normalized)","datatype":"text","index":0,"path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Bib Record","from":"acp.acn","link":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"id":"acp.acn.bre","jtype":"inner","uplink":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"classname":"bre","struct":{"name":"bre","label":"Bibliographic Record","table":"biblio.record_entry","core":true,"pkey":"id","pkey_sequence":"biblio.record_entry_id_seq","core_label":"Core sources","classname":"bre"},"table":"biblio.record_entry"},{"label":"Simple Record Extracts ","from":"acp.acn.bre","link":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"id":"acp.acn.bre.rmsr","jtype":"inner","uplink":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"classname":"rmsr","struct":{"name":"rmsr","label":"Fast Simple Record Extracts","table":"reporter.materialized_simple_record","pkey":"id","core_label":"Non-core sources","classname":"rmsr"},"table":"reporter.materialized_simple_record"}],"path_label":"Item -> Call Number/Volume (inner) -> Bib Record (inner) -> Simple Record Extracts  (inner)","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"title","label":"Title Proper (normalized)","datatype":"text","index":1,"path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Bib Record","from":"acp.acn","link":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"id":"acp.acn.bre","jtype":"inner","uplink":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"classname":"bre","struct":{"name":"bre","label":"Bibliographic Record","table":"biblio.record_entry","core":true,"pkey":"id","pkey_sequence":"biblio.record_entry_id_seq","core_label":"Core sources","classname":"bre"},"table":"biblio.record_entry"},{"label":"Simple Record Extracts ","from":"acp.acn.bre","link":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"id":"acp.acn.bre.rmsr","jtype":"inner","uplink":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"classname":"rmsr","struct":{"name":"rmsr","label":"Fast Simple Record Extracts","table":"reporter.materialized_simple_record","pkey":"id","core_label":"Non-core sources","classname":"rmsr"},"table":"reporter.materialized_simple_record"}],"path_label":"Item -> Call Number/Volume (inner) -> Bib Record (inner) -> Simple Record Extracts  (inner)","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"isbn","label":"ISBN","datatype":"text","index":2,"path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Bib Record","from":"acp.acn","link":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"id":"acp.acn.bre","jtype":"inner","uplink":{"name":"record","label":"Bib Record","type":"link","key":"id","class":"bre","reltype":"has_a","datatype":"link"},"classname":"bre","struct":{"name":"bre","label":"Bibliographic Record","table":"biblio.record_entry","core":true,"pkey":"id","pkey_sequence":"biblio.record_entry_id_seq","core_label":"Core sources","classname":"bre"},"table":"biblio.record_entry"},{"label":"Simple Record Extracts ","from":"acp.acn.bre","link":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"id":"acp.acn.bre.rmsr","jtype":"inner","uplink":{"name":"simple_record","label":"Simple Record Extracts ","virtual":true,"type":"link","key":"id","class":"rmsr","reltype":"might_have","datatype":"link"},"classname":"rmsr","struct":{"name":"rmsr","label":"Fast Simple Record Extracts","table":"reporter.materialized_simple_record","pkey":"id","core_label":"Non-core sources","classname":"rmsr"},"table":"reporter.materialized_simple_record"}],"path_label":"Item -> Call Number/Volume (inner) -> Bib Record (inner) -> Simple Record Extracts  (inner)","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"name","label":"Call Number Owning Library","i18n":true,"datatype":"text","index":3,"path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"},{"label":"Owning Library","from":"acp.acn","link":{"name":"owning_lib","label":"Owning Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"id":"acp.acn.aou","jtype":"inner","uplink":{"name":"owning_lib","label":"Owning Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"classname":"aou","struct":{"name":"aou","label":"Organizational Unit","table":"actor.org_unit","pkey":"id","pkey_sequence":"actor.org_unit_id_seq","core_label":"Non-core sources","classname":"aou"},"table":"actor.org_unit"}],"path_label":"Item -> Call Number/Volume (inner) -> Owning Library (inner)","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"circ_count","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Total Circulation Count, Including Legacy","from":"acp","link":{"name":"total_circ_count","label":"Total Circulations","virtual":true,"type":"link","key":"id","class":"erfcc","reltype":"might_have","datatype":"link"},"id":"acp.erfcc","jtype":"inner","uplink":{"name":"total_circ_count","label":"Total Circulations","virtual":true,"type":"link","key":"id","class":"erfcc","reltype":"might_have","datatype":"link"},"classname":"erfcc","struct":{"name":"erfcc","label":"Total Circulation Count, Including Legacy","table":"extend_reporter.full_circ_count","pkey":"id","core_label":"Non-core sources","classname":"erfcc"},"table":"extend_reporter.full_circ_count"}],"index":4,"label":"Total Circulation Count","datatype":"int","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item :: Total Circulations"},{"name":"name","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Organizational Unit","from":"acp","link":{"name":"circ_lib","label":"Circulating Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"id":"acp.aou","jtype":"inner","uplink":{"name":"circ_lib","label":"Circulating Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"classname":"aou","struct":{"name":"aou","label":"Organizational Unit","table":"actor.org_unit","pkey":"id","pkey_sequence":"actor.org_unit_id_seq","core_label":"Non-core sources","classname":"aou"},"table":"actor.org_unit"}],"index":5,"label":"Copy Circulating Library","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item :: Circulating Library"},{"name":"name","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Copy/Shelving Location","from":"acp","link":{"name":"location","label":"Shelving Location","type":"link","key":"id","class":"acpl","reltype":"has_a","datatype":"link"},"id":"acp.acpl","jtype":"inner","uplink":{"name":"location","label":"Shelving Location","type":"link","key":"id","class":"acpl","reltype":"has_a","datatype":"link"},"classname":"acpl","struct":{"name":"acpl","label":"Copy/Shelving Location","table":"asset.copy_location","pkey":"id","pkey_sequence":"asset.copy_location_id_seq","core_label":"Non-core sources","classname":"acpl"},"table":"asset.copy_location"}],"index":6,"label":"Shelving Location","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item :: Shelving Location"},{"name":"active_date","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":7,"label":"Active Date/Time","datatype":"timestamp","doc_text":"","transform":{"label":"Date","transform":"date","aggregate":null},"path_label":"Item"},{"name":"barcode","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":8,"label":"Barcode","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item"},{"name":"label","label":"Call Number Label","datatype":"text","index":9,"path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"}],"path_label":"Item -> Call Number/Volume (inner)","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""}],"filter_cols":[{"name":"id","label":"Call Number/Volume ID","datatype":"id","index":0,"path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"},{"label":"Call Number/Volume","from":"acp","link":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"id":"acp.acn","jtype":"inner","uplink":{"name":"call_number","label":"Call Number/Volume","type":"link","key":"id","class":"acn","reltype":"has_a","datatype":"link"},"classname":"acn","struct":{"name":"acn","label":"Call Number/Volume","table":"asset.call_number","pkey":"id","pkey_sequence":"asset.call_number_id_seq","core_label":"Non-core sources","classname":"acn"},"table":"asset.call_number"}],"path_label":"Item -> Call Number/Volume (inner)","operator":{"label":"Not in list","op":"not in"},"transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":"","value":"-1"},{"name":"circ_lib","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":1,"label":"Circulating Library","datatype":"org_unit","doc_text":"Select a library, then click Add.","operator":{"op":"in","label":"In list"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item"},{"name":"circ_modifier","path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"index":2,"label":"Circulation Modifier","datatype":"link","doc_text":"","operator":{"op":"is","label":"Is NULL"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Item"},{"name":"deleted","label":"Is Deleted","datatype":"bool","index":3,"path":[{"label":"Item","id":"acp","jtype":"inner","classname":"acp","struct":{"name":"acp","label":"Item","table":"asset.copy","core":true,"pkey":"id","pkey_sequence":"asset.copy_id_seq","core_label":"Core sources","classname":"acp"},"table":"asset.copy"}],"path_label":"Item","operator":{"op":"=","label":"Equals"},"transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":"","value":"f"}]}