{"id":14116,"date":"2018-05-09T07:13:07","date_gmt":"2018-05-09T07:13:07","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=14116"},"modified":"2018-05-09T07:13:07","modified_gmt":"2018-05-09T07:13:07","slug":"9-1-9-custom-report-filtering-and-grouping","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/9-1-9-custom-report-filtering-and-grouping\/","title":{"rendered":"9.1.9. Custom Report Filtering and Grouping"},"content":{"rendered":"

Basic Use<\/h2>\n
\n

This is the basic structure of a custom report. This report lists order lines of tickets.<\/p>\n

\"\"<\/p>\n

Adding quantity column to report;<\/p>\n

\"\"<\/p>\n

Adding quantity summary;<\/p>\n

\"\"<\/p>\n

Filtering<\/h2>\n
\n

You can filter items by Menu Item Group. You should use (MG=x) expression for that. This report will display only Breakfast items.<\/p>\n

\"\"<\/p>\n

Another report will be added to display Misc Items. To separate reports from each other it is used\u00a0>Label<\/code>\u00a0syntax to add bold lines between reports.<\/p>\n

\"\"<\/p>\n

Grouping<\/h2>\n
\n

You can add unlimited number of reports to display more categories. However it will be hard to prepare a report if you have more menu categories. You can use \u201cParameter List\u201d feature instead of addding a report for each filter value you need. Some report will be prepared by using a parameter list.<\/p>\n

\"\"<\/p>\n

You’ll probably want all Menu Categories that exists in that report. Instead of hardcoding all groups one by one you can use another report tag to fetch these values. You should replace @Breakfast,Misc line with a report tag so your parameter list will generate automatically.<\/p>\n

\"\"<\/p>\n

Still same report generates but there is no hardcoded value so as we add new menu item groups to SambaPOS they’ll appear in report automatically.<\/p>\n

It is time to execute\u00a0{REPORT ORDER DETAILS:O.ItemGroup.asc::,}<\/code>\u00a0tag individually to show what it exactly returns.<\/p>\n

\"\"<\/p>\n

That generates a comma separated list of Menu Item groups that appears in the report. Being able to get menu groups that exists in report is a great feature so if you normally have a \u201cPizza\u201d group but it does not exists in the report a blank section will not appear for it.<\/p>\n

 <\/p>\n<\/div>\n<\/div>\n

 <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Basic Use This is the basic structure of a custom report. This report lists order lines of tickets. Adding quantity column to report; Adding quantity summary; Filtering You can filter items by Menu Item Group. You should use (MG=x) expression for that. This report will display only Breakfast items. Another report will be added to […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-14116","post","type-post","status-publish","format-standard","hentry","category-reports"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=14116"}],"version-history":[{"count":1,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14116\/revisions"}],"predecessor-version":[{"id":14133,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14116\/revisions\/14133"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=14116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=14116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=14116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}