Database Query T'ool

General Information about POS Pizza 6 and 7
Member
User avatar
Posts: 27
Joined: Thu Apr 28, 2016 1:49 pm
Location: Charleston, IL

Database Query T'ool

Postby wcpc » Mon Sep 02, 2019 10:37 pm

I installed the latest 7.22 CS version... and I see a "new addition" is the Database Query Tool... I have looked for it everywhere... where is it located, and tell me a little about what it's uses are please...
JimD
Windy City Pizza
Charleston, IL

Site Admin
User avatar
Posts: 2379
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Database Query T'ool

Postby Scott » Tue Sep 03, 2019 10:01 am

The tool allows you to query the database using SQL and output to a CSV file any data that is in the query. It is template based so that you can have them run as events or scheduled using something like the Windows scheduler.

Look in the installation folder. There is a document file (PDF) and some sample templates which are installed if you selected the option during install.


Scott

New Member
Posts: 3
Joined: Tue Mar 14, 2017 8:38 am

Re: Database Query T'ool

Postby seaside » Tue Sep 03, 2019 12:28 pm

Could this be used to show all orders that were tax exempt for this year?

Site Admin
User avatar
Posts: 2379
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Database Query T'ool

Postby Scott » Tue Sep 03, 2019 3:23 pm

seaside wrote:Could this be used to show all orders that were tax exempt for this year?


Yes. Just create a query to look for those specific parameters, and pass it to the tool.

Off the top of my head that would look something like;
Code: Select all
server=auto
database=pospizza.pz6
query=SELECT order_number, order_date FROM orders_tbl
      WHERE tax_exempt != 0 AND voided_order=0 AND record_type=1 AND
      order_date BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59'
      ORDER BY order_number ASC;
csv=tax_exempt_orders.csv


Scott

Return to General Information v6 & v7

Who is online

Users browsing this forum: No registered users and 3 guests