Differences

This shows you the differences between two versions of the page.

--- scratchpad:sample_reporter_templates [2009/12/04 12:15] – aatre
+++ scratchpad:sample_reporter_templates [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 12: / Line 12: @@
 Run this SQL insert to create a template folder "Sample Reports".
-<code>
+<code sql>
-# 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);
 </code>
@@ Line 23: / Line 23: @@
 **Description:** List all new items for selected date range and library.
-<code>
+<code sql>
 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":"acp-location-acpl","table":"asset.copy_location","key":"id","label":"Item :: Shelving Location","alias":"c17ecc44e3cd2de457e5c9f1e6e0a26f","idlclass":"acpl","template_path":"acp-location"},"call_number-7d74f3b92b19da5e606d737d339a9679":{"path":"acp-call_number-acn-record","table":"asset.call_number","key":"id","label":"Item :: Call Number/Volume","alias":"286d7899ae25bee8bdd7dcde49f9e0b7","idlclass":"acn","template_path":"acp-call_number","join":{"record-286d7899ae25bee8bdd7dcde49f9e0b7":{"path":"acp-call_number-acn-record-bre","table":"biblio.record_entry","key":"id","label":"Item -> Call Number/Volume :: Bib Record","alias":"640e9f1ba83104cf4de312413f51b877","idlclass":"bre","template_path":"acp-call_number.acn-record"}}}},"label":"Item","idlclass":"acp","template_path":"acp"},"where":[{"alias":"Creation Date/Time","column":{"colname":"create_date","transform":"date","transform_label":"Date"},"path":"acp-create_date","relation":"7d74f3b92b19da5e606d737d339a9679","condition":{"between":"::P0"}},{"alias":"Circulating Library","column":{"colname":"circ_lib","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_lib","relation":"7d74f3b92b19da5e606d737d339a9679","condition":{"in":"::P1"}}],"having":[],"order_by":[],"rel_cache":{"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 Proper (normalized)","datatype":"text","op":"=","op_label":"Equals","op_value":{}},"author":{"colname":"author","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Author (normalized)","datatype":"text","op":"=","op_label":"Equals","op_value":{}},"pubdate":{"colname":"pubdate","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Publication Year (normalized)","datatype":"int","op":"=","op_label":"Equals","op_value":{}},"isbn":{"colname":"isbn","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"ISBN","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"order_by":[{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"title"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"author"},{"relation":"c17ecc44e3cd2de457e5c9f1e6e0a26f","field":"name"},{"relation":"286d7899ae25bee8bdd7dcde49f9e0b7","field":"label"},{"relation":"7d74f3b92b19da5e606d737d339a9679","field":"create_date"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"pubdate"},{"relation":"640e9f1ba83104cf4de312413f51b877","field":"id"},{"relation":"df8d81aecbe6b10702cbd762ac04cac9","field":"isbn"},{"relation":"ab9ff91ac334900edb50f0a5a8e3501f","field":"shortname"}],"7d74f3b92b19da5e606d737d339a9679":{"label":"Item","alias":"7d74f3b92b19da5e606d737d339a9679","path":"acp","reltype":"","idlclass":"acp","table":"asset.copy","fields":{"dis_tab":{"create_date":{"colname":"create_date","transform":"date","aggregate":null,"params":null,"transform_label":"Date","alias":"Creation Date/Time","datatype":"timestamp","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{"create_date":{"colname":"create_date","transform":"date","aggregate":null,"params":null,"transform_label":"Date","alias":"Creation Date/Time","datatype":"timestamp","op":"between","op_label":"Between","op_value":{}},"circ_lib":{"colname":"circ_lib","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Circulating Library","datatype":"org_unit","op":"in","op_label":"In list","op_value":{}}},"aggfilter_tab":{}}},"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":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Short (Policy) Name","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"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":"Name","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"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 Label","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"640e9f1ba83104cf4de312413f51b877":{"label":"Item -> Call Number/Volume :: Bib Record","alias":"640e9f1ba83104cf4de312413f51b877","path":"acp-call_number.acn-record","reltype":"has_a","idlclass":"bre","table":"biblio.record_entry","fields":{"dis_tab":{"id":{"colname":"id","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Record ID","datatype":"id","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}}}}', 1);
 </code>
@@ Line 32: / Line 32: @@
 **Description:** List all circulations for selected library and month.
-<code>
+<code sql>
 INSERT INTO reporter.template (id, owner, create_time, name, description, data, folder) VALUES (2, 1, '2009-10-01 10:41:47.226744-06', 'Circs by Month', 'List all circulations for selected library and month.', '{"version":2,"core_class":"circ","select":[{"alias":"Check out month","column":{"colname":"xact_start","transform":"month_trunc","transform_label":"Year + Month"},"path":"circ-xact_start","relation":"f45381a54504218e39aca33492d29306"},{"alias":"Shelving location","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"circ-target_copy-acp-location-acpl-name","relation":"016fb9411002aa9643f0ae914dc920e6"},{"alias":"Circ Count","column":{"colname":"id","transform":"count_distinct","transform_label":"Count Distinct"},"path":"circ-id","relation":"f45381a54504218e39aca33492d29306"}],"from":{"path":"circ-target_copy","table":"action.circulation","label":"Circulation","alias":"f45381a54504218e39aca33492d29306","idlclass":"circ","template_path":"circ","join":{"target_copy-f45381a54504218e39aca33492d29306":{"path":"circ-target_copy-acp-location","table":"asset.copy","key":"id","alias":"ec5d1b4798c830f1d9c4211d25c7742a","join":{"location-ec5d1b4798c830f1d9c4211d25c7742a":{"path":"circ-target_copy-acp-location-acpl","table":"asset.copy_location","key":"id","label":"Circulation -> Item :: Shelving Location","alias":"016fb9411002aa9643f0ae914dc920e6","idlclass":"acpl","template_path":"circ-target_copy.acp-location"}}}}},"where":[{"alias":"Check Out Date/Time","column":{"colname":"xact_start","transform":"month_trunc","transform_label":"Year + Month"},"path":"circ-xact_start","relation":"f45381a54504218e39aca33492d29306","condition":{"in":"::P0"}},{"alias":"Circulating Library","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","reltype":"","idlclass":"circ","table":"action.circulation","fields":{"dis_tab":{"id":{"colname":"id","transform":"count_distinct","aggregate":"true","params":"undefined","transform_label":"Count Distinct","alias":"Circ Count","datatype":"id","op":"=","op_label":"Equals","op_value":{}},"xact_start":{"colname":"xact_start","transform":"month_trunc","aggregate":"undefined","params":"undefined","transform_label":"Year + Month","alias":"Check out month","datatype":"timestamp","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{"xact_start":{"colname":"xact_start","transform":"month_trunc","aggregate":"undefined","params":"undefined","transform_label":"Year + Month","alias":"Check Out Date/Time","datatype":"timestamp","op":"in","op_label":"In list","op_value":{}},"circ_lib":{"colname":"circ_lib","transform":"Bare","aggregate":"undefined","params":"undefined","transform_label":"Raw Data","alias":"Circulating Library","datatype":"org_unit","op":"in","op_label":"In list","op_value":{}}},"aggfilter_tab":{}}},"order_by":[{"relation":"f45381a54504218e39aca33492d29306","field":"xact_start"},{"relation":"016fb9411002aa9643f0ae914dc920e6","field":"name"},{"relation":"f45381a54504218e39aca33492d29306","field":"id"}],"016fb9411002aa9643f0ae914dc920e6":{"label":"Circulation -> Item :: Shelving Location","alias":"016fb9411002aa9643f0ae914dc920e6","path":"circ-target_copy.acp-location","reltype":"has_a","idlclass":"acpl","table":"asset.copy_location","fields":{"dis_tab":{"name":{"colname":"name","transform":"Bare","aggregate":"undefined","params":"undefined","transform_label":"Raw Data","alias":"Shelving location","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}}}}', 1);
 </code>
@@ Line 40: / Line 40: @@
 **Description:** List all books in collection. [Could get to be a huge report since it is not limited by anything.]
-<code>
+<code sql>
 INSERT INTO reporter.template (id, owner, create_time, name, description, data, folder) VALUES (3, 1, '2009-10-01 10:04:05.739197-06', 'Books in collection', 'List all books in collection.', '{"version":2,"core_class":"bre","select":[{"alias":"Author (normalized)","column":{"colname":"author","transform":"Bare","transform_label":"Raw Data"},"path":"bre-simple_record-rmsr-biblio_record-bre-simple_record-rmsr-author","relation":"f99e43559b41300beb113d66fba4e407"},{"alias":"Title Proper (normalized)","column":{"colname":"title","transform":"Bare","transform_label":"Raw Data"},"path":"bre-simple_record-rmsr-biblio_record-bre-simple_record-rmsr-title","relation":"f99e43559b41300beb113d66fba4e407"},{"alias":"Record ID","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data"},"path":"bre-simple_record-rmsr-biblio_record-bre-simple_record-rmsr-id","relation":"f99e43559b41300beb113d66fba4e407"}],"from":{"path":"bre-simple_record","table":"biblio.record_entry","alias":"a23baa18c3b4a3421dfdf18cb3271518","join":{"id-rmsr-id-a23baa18c3b4a3421dfdf18cb3271518":{"path":"bre-simple_record-rmsr-biblio_record","table":"reporter.materialized_simple_record","key":"id","type":"left","alias":"340a5bc269c2796366e8d218ac4e560e","join":{"id-bre-id-340a5bc269c2796366e8d218ac4e560e":{"type":"left","path":"bre-simple_record-rmsr-biblio_record-bre-simple_record","table":"biblio.record_entry","key":"id","alias":"df6e5648150fd835624ba36df30b9267","join":{"id-rmsr-id-df6e5648150fd835624ba36df30b9267":{"type":"left","path":"bre-simple_record-rmsr-biblio_record-bre-simple_record-rmsr","table":"reporter.materialized_simple_record","key":"id","label":"Bibliographic Record -> Fast Simple Record Extracts -> Bibliographic Record :: Simple Record Extracts ","alias":"f99e43559b41300beb113d66fba4e407","idlclass":"rmsr","template_path":"bre-simple_record.rmsr-biblio_record.bre-simple_record"}}}}}}},"where":[],"having":[],"order_by":[],"rel_cache":{"f99e43559b41300beb113d66fba4e407":{"label":"Bibliographic Record -> Fast Simple Record Extracts -> Bibliographic Record :: Simple Record Extracts ","alias":"f99e43559b41300beb113d66fba4e407","path":"bre-simple_record.rmsr-biblio_record.bre-simple_record","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)","datatype":"text","op":"=","op_label":"Equals","op_value":{}},"title":{"colname":"title","transform":"Bare","aggregate":"undefined","params":"undefined","transform_label":"Raw Data","alias":"Title Proper (normalized)","datatype":"text","op":"=","op_label":"Equals","op_value":{}},"id":{"colname":"id","transform":"Bare","aggregate":"undefined","params":"undefined","transform_label":"Raw Data","alias":"Record ID","datatype":"id","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"order_by":[{"relation":"f99e43559b41300beb113d66fba4e407","field":"author"},{"relation":"f99e43559b41300beb113d66fba4e407","field":"title"},{"relation":"f99e43559b41300beb113d66fba4e407","field":"id"}]}}', 1);
 </code>
@@ Line 48: / Line 48: @@
 **Description:** Total item counts using a before creation date and circ modifier.
-<code>
+<code sql>
 INSERT INTO reporter.template (id, owner, create_time, name, description, data, folder) VALUES (4, 1, '2009-10-01 10:48:40.75899-06', 'Item Count (PINES)', 'Total item counts using a before creation date and circ modifier.', '{"version":2,"core_class":"acp","select":[{"alias":"Short (Policy) Name","column":{"colname":"shortname","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_lib-aou-shortname","relation":"ab9ff91ac334900edb50f0a5a8e3501f"},{"alias":"Copy ID","column":{"colname":"id","transform":"count_distinct","transform_label":"Count Distinct"},"path":"acp-id","relation":"7d74f3b92b19da5e606d737d339a9679"}],"from":{"path":"acp-call_number","table":"asset.copy","alias":"7d74f3b92b19da5e606d737d339a9679","join":{"circ_lib-eb2d7f1fefe6a54c8f29fd69d7d4f600":{"path":"acp-circ_lib-aou","table":"actor.org_unit","key":"id","label":"Item :: Circulating Library","alias":"ab9ff91ac334900edb50f0a5a8e3501f","idlclass":"aou","template_path":"acp-circ_lib"},"editor-7d74f3b92b19da5e606d737d339a9679":{"path":"acp-editor-au","table":"actor.usr","key":"id","label":"Item :: Last Editing User","alias":"03702337177587977a5b3b194af79581","idlclass":"au","template_path":"acp-editor"},"call_number-7d74f3b92b19da5e606d737d339a9679":{"path":"acp-call_number-acn","table":"asset.call_number","key":"id","label":"Item :: Call Number/Volume","alias":"286d7899ae25bee8bdd7dcde49f9e0b7","idlclass":"acn","template_path":"acp-call_number"}},"label":"Item","idlclass":"acp","template_path":"acp"},"where":[{"alias":"Organizational Unit ID","column":{"colname":"id","transform":"Bare","transform_label":"Raw Data"},"path":"acp-circ_lib-aou-id","relation":"ab9ff91ac334900edb50f0a5a8e3501f","condition":{"in":"::P0"}},{"alias":"Is Deleted","column":{"colname":"deleted","transform":"Bare","transform_label":"Raw Data"},"path":"acp-editor-au-deleted","relation":"03702337177587977a5b3b194af79581","condition":{"=":"f"}},{"alias":"Create Date/Time","column":{"colname":"create_date","transform":"date","transform_label":"Date"},"path":"acp-call_number-acn-create_date","relation":"286d7899ae25bee8bdd7dcde49f9e0b7","condition":{"<":"::P1"}}],"having":[],"order_by":[],"rel_cache":{"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":"Bare","aggregate":"undefined","params":"undefined","transform_label":"Raw Data","alias":"Short (Policy) Name","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"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":{}}},"aggfilter_tab":{}}},"order_by":[{"relation":"ab9ff91ac334900edb50f0a5a8e3501f","field":"shortname"},{"relation":"7d74f3b92b19da5e606d737d339a9679","field":"id"}],"7d74f3b92b19da5e606d737d339a9679":{"label":"Item","alias":"7d74f3b92b19da5e606d737d339a9679","path":"acp","reltype":"","idlclass":"acp","table":"asset.copy","fields":{"dis_tab":{"id":{"colname":"id","transform":"count_distinct","aggregate":"true","params":"undefined","transform_label":"Count Distinct","alias":"Copy ID","datatype":"id","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"03702337177587977a5b3b194af79581":{"label":"Item :: Last Editing User","alias":"03702337177587977a5b3b194af79581","path":"acp-editor","reltype":"has_a","idlclass":"au","table":"actor.usr","fields":{"dis_tab":{},"filter_tab":{"deleted":{"colname":"deleted","transform":"Bare","aggregate":"undefined","params":"undefined","transform_label":"Raw Data","alias":"Is Deleted","datatype":"bool","op":"=","op_label":"Equals","op_value":{"value":"f","label":"False"}}},"aggfilter_tab":{}}},"286d7899ae25bee8bdd7dcde49f9e0b7":{"label":"Item :: Call Number/Volume","alias":"286d7899ae25bee8bdd7dcde49f9e0b7","path":"acp-call_number","reltype":"has_a","idlclass":"acn","table":"asset.call_number","fields":{"dis_tab":{},"filter_tab":{"create_date":{"colname":"create_date","transform":"date","aggregate":"undefined","params":"undefined","transform_label":"Date","alias":"Create Date/Time","datatype":"timestamp","op":"<","op_label":"Before (Date/Time)","op_value":{}}},"aggfilter_tab":{}}}}}', 1);
 </code>
@@ Line 56: / Line 56: @@
 **Description:** Counts of items in item stat cats.
-<code>
+<code sql>
 INSERT INTO reporter.template (id, owner, create_time, name, description, data, folder) VALUES (5, 1, '2009-10-01 10:24:24.127575-06', 'Items in Statistical Categories', 'Counts of items in item stat cats.', '{"version":2,"core_class":"asce","select":[{"alias":"Name","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"asce-stat_cat-asc-name","relation":"c7d7c50e4af523cd8de3be16fff02a66"},{"alias":"Value","column":{"colname":"value","transform":"count_distinct","transform_label":"Count Distinct"},"path":"asce-value","relation":"65d25b8523a93bf7eb8c3a806e5d1375"}],"from":{"path":"asce-stat_cat","table":"asset.stat_cat_entry","label":"Item Stat Cat Entry","alias":"65d25b8523a93bf7eb8c3a806e5d1375","idlclass":"asce","template_path":"asce","join":{"stat_cat-65d25b8523a93bf7eb8c3a806e5d1375":{"path":"asce-stat_cat-asc","table":"asset.stat_cat","key":"id","label":"Item Stat Cat Entry :: Stat Cat","alias":"c7d7c50e4af523cd8de3be16fff02a66","idlclass":"asc","template_path":"asce-stat_cat"}}},"where":[],"having":[],"order_by":[],"rel_cache":{"65d25b8523a93bf7eb8c3a806e5d1375":{"label":"Item Stat Cat Entry","alias":"65d25b8523a93bf7eb8c3a806e5d1375","path":"asce","reltype":"","idlclass":"asce","table":"asset.stat_cat_entry","fields":{"dis_tab":{"value":{"colname":"value","transform":"count_distinct","aggregate":true,"params":null,"transform_label":"Count Distinct","alias":"Value","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}},"order_by":[{"relation":"c7d7c50e4af523cd8de3be16fff02a66","field":"name"},{"relation":"65d25b8523a93bf7eb8c3a806e5d1375","field":"value"}],"c7d7c50e4af523cd8de3be16fff02a66":{"label":"Item Stat Cat Entry :: Stat Cat","alias":"c7d7c50e4af523cd8de3be16fff02a66","path":"asce-stat_cat","reltype":"has_a","idlclass":"asc","table":"asset.stat_cat","fields":{"dis_tab":{"name":{"colname":"name","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw Data","alias":"Name","datatype":"text","op":"=","op_label":"Equals","op_value":{}}},"filter_tab":{},"aggfilter_tab":{}}}}}', 1);
 </code>