Template created on XUL"


 {"version":4,"doc_url":"","core_class":"circ","select":[{"alias":"patron home lib","field_doc":"","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"circ-usr-au-home_ou-aou-name","relation":"7d544dbda3f4628281b678c77818195b"},{"alias":"patron group","field_doc":"","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"circ-usr-au-profile-pgt-name","relation":"68d4ec98c1db9ec1f039affcbca7ee2c"},{"alias":"patron count","field_doc":"","column":{"colname":"id","transform":"count_distinct","transform_label":"Count Distinct"},"path":"circ-usr-au-id","relation":"4d40dc21e7ab3d1a4a8c37371d3982c4"}],"from":{"path":"circ-usr","table":"action.circulation","label":"Circulation","alias":"f45381a54504218e39aca33492d29306","idlclass":"circ","template_path":"circ","join":{"usr-f45381a54504218e39aca33492d29306":{"key":"id","path":"circ-usr-au-profile","table":"actor.usr","alias":"4d40dc21e7ab3d1a4a8c37371d3982c4","join":{"home_ou-207c1dae9c7662850f0760d334364007":{"key":"id","path":"circ-usr-au-home_ou-aou","table":"actor.org_unit","label":"Circulation -> ILS User :: Home Library","alias":"7d544dbda3f4628281b678c77818195b","idlclass":"aou","template_path":"circ-usr.au-home_ou"},"profile-4d40dc21e7ab3d1a4a8c37371d3982c4":{"key":"id","path":"circ-usr-au-profile-pgt","table":"permission.grp_tree","label":"Circulation -> ILS User :: Main (Profile) Permission Group","alias":"68d4ec98c1db9ec1f039affcbca7ee2c","idlclass":"pgt","template_path":"circ-usr.au-profile"}},"label":"Circulation :: Patron","idlclass":"au","template_path":"circ-usr"}}},"where":[{"alias":"Check Out Date/Time","field_doc":"Use the calendar widget to choose dates (inclusive). Earlier date in the upper box. Use Relative Date for recurring reports.","column":{"colname":"xact_start","transform":"date","transform_label":"Date"},"path":"circ-xact_start","relation":"f45381a54504218e39aca33492d29306","condition":{"between":"::P0"}},{"alias":"Circulating Library","field_doc":"This is Checkout Library. Highlight a library, then click Add.","column":{"colname":"circ_lib","transform":"Bare","transform_label":"Raw Data"},"path":"circ-circ_lib","relation":"f45381a54504218e39aca33492d29306","condition":{"in":"::P1"}}],"having":[],"order_by":[],"rel_cache":{"f45381a54504218e39aca33492d29306":{"label":"Circulation","alias":"f45381a54504218e39aca33492d29306","path":"circ","join":"","reltype":"","idlclass":"circ","table":"action.circulation","fields":{"dis_tab":{},"filter_tab":{"xact_start":{"colname":"xact_start","transform":"date","aggregate":null,"params":null,"transform_label":"Date","alias":"Check Out Date/Time","join":"","datatype":"timestamp","op":"between","op_label":"Between","op_value":{},"ield_doc":"Use the calendar widget to choose dates (inclusive). Earlier date in the upper box. Use Relative Date for recurring reports."},"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":"This is Checkout Library. Highlight a library, then click Add."}},"aggfilter_tab":{}}},"order_by":[{"relation":"7d544dbda3f4628281b678c77818195b","field":"name"},{"relation":"68d4ec98c1db9ec1f039affcbca7ee2c","field":"name"},{"relation":"4d40dc21e7ab3d1a4a8c37371d3982c4","field":"id"}],"7d544dbda3f4628281b678c77818195b":{"label":"Circulation -> ILS User :: Home Library","alias":"7d544dbda3f4628281b678c77818195b","path":"circ-usr.au-home_ou","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":"patron home lib","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{},"aggfilter_tab":{}}},"4d40dc21e7ab3d1a4a8c37371d3982c4":{"label":"Circulation :: Patron","alias":"4d40dc21e7ab3d1a4a8c37371d3982c4","path":"circ-usr","join":"","reltype":"has_a","idlclass":"au","table":"actor.usr","fields":{"dis_tab":{"id":{"colname":"id","transform":"count_distinct","aggregate":true,"params":null,"transform_label":"Count Distinct","alias":"patron count","join":"","datatype":"id","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{},"aggfilter_tab":{}}},"68d4ec98c1db9ec1f039affcbca7ee2c":{"label":"Circulation -> ILS User :: Main (Profile) Permission Group","alias":"68d4ec98c1db9ec1f039affcbca7ee2c","path":"circ-usr.au-profile","join":"","reltype":"has_a","idlclass":"pgt","table":"permission.grp_tree","fields":{"dis_tab":{"name":{"colname":"name","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"patron group","join":"","datatype":"text","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{},"aggfilter_tab":{}}}}}


Template cloned without any editing:


 {"version":5,"doc_url":"","core_class":"circ","select":[{"alias":"patron home lib","path":"aou-name","field_doc":"","relation":"7d544dbda3f4628281b678c77818195b","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"patron count","path":"au-id","field_doc":"","relation":"4d40dc21e7ab3d1a4a8c37371d3982c4","column":{"colname":"id","transform":"count_distinct","transform_label":"Count Distinct","aggregate":true}},{"alias":"patron group","path":"pgt-name","field_doc":"","relation":"68d4ec98c1db9ec1f039affcbca7ee2c","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","aggregate":false}}],"from":{"alias":"f45381a54504218e39aca33492d29306","path":"circ-circ","table":"action.circulation","idlclass":"circ","join":{"usr-66d162b787aaa3d016fbc5f1d4e89ffb":{"type":"inner","key":"id","alias":"4d40dc21e7ab3d1a4a8c37371d3982c4","path":"circ-usr","table":"actor.usr","idlclass":"au","join":{"home_ou-8e7f2cd4fbecf3e91eb3b4bc4119dc9c":{"type":"inner","key":"id","alias":"7d544dbda3f4628281b678c77818195b","path":"circ-usr-home_ou","table":"actor.org_unit","idlclass":"aou","label":"Circulation -> ILS User :: Home Library"},"profile-a5c36f2a41667fe007fe4ab3032bc9ee":{"type":"inner","key":"id","alias":"68d4ec98c1db9ec1f039affcbca7ee2c","path":"circ-usr-profile","table":"permission.grp_tree","idlclass":"pgt","label":"Circulation -> ILS User :: Main (Profile) Permission Group"}},"label":"Circulation :: Patron"}},"label":"Circulation"},"where":[{"alias":"Check Out Date/Time","path":"circ-xact_start","field_doc":"Use the calendar widget to choose dates (inclusive). Earlier date in the upper box. Use Relative Date for recurring reports.","relation":"f45381a54504218e39aca33492d29306","column":{"colname":"xact_start","transform":"date","transform_label":"Date","aggregate":0},"condition":{"between":"::P0"}},{"alias":"Circulating Library","path":"circ-circ_lib","field_doc":"This is Checkout Library. Highlight a library, then click Add.","relation":"f45381a54504218e39aca33492d29306","column":{"colname":"circ_lib","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"in":"::P1"}}],"having":[],"display_cols":[{"name":"name","path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"},{"label":"ILS User","from":"circ","link":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"id":"circ.au","jtype":"inner","uplink":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"},{"label":"Organizational Unit","from":"au","link":{"name":"home_ou","label":"Home Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"id":"au.aou","jtype":"inner","uplink":{"name":"home_ou","label":"Home 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":0,"label":"patron home lib","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Circulation -> ILS User :: Home Library"},{"name":"id","path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"},{"label":"ILS User","from":"circ","link":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"id":"circ.au","jtype":"inner","uplink":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"index":1,"label":"patron count","datatype":"id","doc_text":"","transform":{"label":"Count Distinct","transform":"count_distinct","aggregate":true},"path_label":"Circulation :: Patron"},{"name":"name","path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"},{"label":"ILS User","from":"circ","link":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"id":"circ.au","jtype":"inner","uplink":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"},{"label":"Permission Group","from":"au","link":{"name":"profile","label":"Main (Profile) Permission Group","type":"link","key":"id","class":"pgt","reltype":"has_a","datatype":"link"},"id":"au.pgt","jtype":"inner","uplink":{"name":"profile","label":"Main (Profile) Permission Group","type":"link","key":"id","class":"pgt","reltype":"has_a","datatype":"link"},"classname":"pgt","struct":{"name":"pgt","label":"Permission Group","table":"permission.grp_tree","pkey":"id","pkey_sequence":"permission.grp_tree_id_seq","core_label":"Non-core sources","classname":"pgt"},"table":"permission.grp_tree"}],"index":2,"label":"patron group","datatype":"text","doc_text":"","transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Circulation -> ILS User :: Main (Profile) Permission Group"}],"filter_cols":[{"name":"xact_start","path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"}],"index":3,"label":"Check Out Date/Time","datatype":"timestamp","doc_text":"Use the calendar widget to choose dates (inclusive). Earlier date in the upper box. Use Relative Date for recurring reports.","operator":{"op":"between","label":"Between"},"transform":{"label":"Date","transform":"date","aggregate":null},"path_label":"Circulation"},{"name":"circ_lib","path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"}],"index":4,"label":"Circulating Library","datatype":"org_unit","doc_text":"This is Checkout Library. Highlight a library, then click Add.","operator":{"op":"in","label":"In list"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Circulation"}]}


Cloned with replaced fields from linked tables:

 {"version":5,"doc_url":"","core_class":"circ","select":[{"alias":"Home Library","path":"aou-name","field_doc":"","relation":"af74c49fe41f4e509e403ca1d45bd1f2","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Patron Count","path":"au-id","field_doc":"","relation":"1506ef56702f6a16663d277d33e286af","column":{"colname":"id","transform":"count_distinct","transform_label":"Count Distinct","aggregate":true}},{"alias":"Group Name","path":"pgt-name","field_doc":"","relation":"2f0d7012d1123de6787447d57cb94c7d","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data","aggregate":false}}],"from":{"alias":"f45381a54504218e39aca33492d29306","path":"circ-circ","table":"action.circulation","idlclass":"circ","join":{"usr-66d162b787aaa3d016fbc5f1d4e89ffb":{"type":"inner","key":"id","alias":"1506ef56702f6a16663d277d33e286af","path":"circ-usr","table":"actor.usr","idlclass":"au","join":{"home_ou-8e7f2cd4fbecf3e91eb3b4bc4119dc9c":{"type":"inner","key":"id","alias":"af74c49fe41f4e509e403ca1d45bd1f2","path":"circ-usr-home_ou","table":"actor.org_unit","idlclass":"aou","label":"Circulation -> Patron (inner) -> Home Library (inner)"},"profile-a5c36f2a41667fe007fe4ab3032bc9ee":{"type":"inner","key":"id","alias":"2f0d7012d1123de6787447d57cb94c7d","path":"circ-usr-profile","table":"permission.grp_tree","idlclass":"pgt","label":"Circulation -> Patron (inner) -> Main (Profile) Permission Group (inner)"}},"label":"Circulation -> Patron (inner)"}},"label":"Circulation"},"where":[{"alias":"Check Out Date/Time","path":"circ-xact_start","field_doc":"Use the calendar widget to choose dates (inclusive). Earlier date in the upper box. Use Relative Date for recurring reports.","relation":"f45381a54504218e39aca33492d29306","column":{"colname":"xact_start","transform":"date","transform_label":"Date","aggregate":0},"condition":{"between":"::P0"}},{"alias":"Circulating Library","path":"circ-circ_lib","field_doc":"This is Checkout Library. Highlight a library, then click Add.","relation":"f45381a54504218e39aca33492d29306","column":{"colname":"circ_lib","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"in":"::P1"}}],"having":[],"display_cols":[{"name":"name","label":"Home Library","i18n":true,"datatype":"text","index":0,"path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"},{"label":"Patron","from":"circ","link":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"id":"circ.au","jtype":"inner","uplink":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"},{"label":"Home Library","from":"circ.au","link":{"name":"home_ou","label":"Home Library","type":"link","key":"id","class":"aou","reltype":"has_a","datatype":"org_unit"},"id":"circ.au.aou","jtype":"inner","uplink":{"name":"home_ou","label":"Home 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":"Circulation -> Patron (inner) -> Home Library (inner)","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"id","label":"Patron Count","datatype":"id","index":1,"path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"},{"label":"Patron","from":"circ","link":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"id":"circ.au","jtype":"inner","uplink":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"Circulation -> Patron (inner)","transform":{"transform":"count_distinct","label":"Count Distinct","aggregate":true},"doc_text":""},{"name":"name","label":"Group Name","i18n":true,"datatype":"text","index":2,"path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"},{"label":"Patron","from":"circ","link":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"id":"circ.au","jtype":"inner","uplink":{"name":"usr","label":"Patron","type":"link","key":"id","class":"au","reltype":"has_a","datatype":"link"},"classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"},{"label":"Main (Profile) Permission Group","from":"circ.au","link":{"name":"profile","label":"Main (Profile) Permission Group","type":"link","key":"id","class":"pgt","reltype":"has_a","datatype":"link"},"id":"circ.au.pgt","jtype":"inner","uplink":{"name":"profile","label":"Main (Profile) Permission Group","type":"link","key":"id","class":"pgt","reltype":"has_a","datatype":"link"},"classname":"pgt","struct":{"name":"pgt","label":"Permission Group","table":"permission.grp_tree","pkey":"id","pkey_sequence":"permission.grp_tree_id_seq","core_label":"Non-core sources","classname":"pgt"},"table":"permission.grp_tree"}],"path_label":"Circulation -> Patron (inner) -> Main (Profile) Permission Group (inner)","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""}],"filter_cols":[{"name":"xact_start","path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"}],"index":3,"label":"Check Out Date/Time","datatype":"timestamp","doc_text":"Use the calendar widget to choose dates (inclusive). Earlier date in the upper box. Use Relative Date for recurring reports.","operator":{"op":"between","label":"Between"},"transform":{"label":"Date","transform":"date","aggregate":null},"path_label":"Circulation"},{"name":"circ_lib","path":[{"label":"Circulation","id":"circ","jtype":"inner","classname":"circ","struct":{"name":"circ","label":"Circulation","table":"action.circulation","core":true,"pkey":"id","pkey_sequence":"money.billable_xact_id_seq","core_label":"Core sources","classname":"circ"},"table":"action.circulation"}],"index":4,"label":"Circulating Library","datatype":"org_unit","doc_text":"This is Checkout Library. Highlight a library, then click Add.","operator":{"op":"in","label":"In list"},"transform":{"label":"Raw Data","transform":"Bare","aggregate":null},"path_label":"Circulation"}]}