The Quick Export tool lets you run queries against the Order
Management database. While it isn't as powerful as reports generated
through the reporting system
with SQL Server Reporting Services, it's quick and easy to use. You can
also use it to create custom order searches that appear in the Orders
Manager Quick Search.
To use the Quick Export tool, select
Quick Export from Order Management Administration:
Utilities, and then click Database Export at the top of the
page.
For information on running queries, see Exporting
Item Records Using the Quick Export Tool. For database objects
other than Items, the procedure is the same; simply select a different
record type.
The Quick Export page includes the following
sections:
| Section |
Description |
| Database Export tab |
Click this tab to open the Database Export form. |
| Database Export form |
Shows the following controls for running a query:
- New Search Menu: Select a record type and, if
applicable, a sub-record type or sort order.
- Saved Searches Menu: Select an existing query
that you have saved.
- Run Search Button: Executes the current
query.
- Max Rows Returned Field: Limits the number of
records returned in the query. The default value is
500.
- Search Name Field: Used to specify a name when
saving the current query.
- Save Button: Saves the current query. For order
searches (only), if you prepend "(QS)" to the search name
(for example, "(QS) Closed Orders Search"), then the search
is also made available in the Quick Search menu in the
Orders Manager. Note that it will not appear there until the
cache refreshes, and it will not show "(QS)" in the
name.
- Delete Button: Deletes the current query.
- Export to Excel Button: Saves the query results
in CSV format in the download folder configured in the
browser.
|
X
Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.