There are 4 options available to customers for data reporting/exporting in X Dispatch. Options will vary depending upon installation type, Cloud or On-Premise.
Basic / Advanced Find query and export
The first option to access the SQL database from X Dispatch for reporting purposes will be to use the Basic find. This option is best suited for times when a basic returned dataset is required. In the image below, you can see an example of the Basic find and the export. This option is best suited for times when a basic returned dataset is required. In the image below, you can see an example of the Basic find and the export.
A Basic find would be used most often when you need a small data sample to verify information. An example is when a customer contacts you asking for a day's worth of data for them.
(For this example we will find orders, where the customer id = 9999 and date ordered, is in a date range)
Run your query
Click Export
Save the file (Cloud Users please see How To Save Files To Your Computer From Cloud for instructions on saving files locally)
