Query Export

Introduction

File:AR Query Export 0.jpg

Query Export: Report List Screen

QUERY EXPORT is a powerful reporting utility in the GH Keystone Product.

It is designed to give users access to data in raw form and contains important protections to prevent users from changing the data.

As of version 2.7.6, queries may be run across multiple companies, creating a single result set which combines the results from the selected companies.

The first screen contains a list of all saved reports. To run one of these reports, simply double-click on the report. You will be prompted for any report values that may be needed (date ranges, etc.)

See Also: Most Excellent Queries

Update Queries

Keys to setting up safe update queries:

• Backup First
• Always run a sample select query using the same where paramaters

When running an update query in Query export:

• You will be asked for the GH Dynamic Super Double Secret Password
• All update queries are committed upon the end of execution (so don't screw up)

Report Setup

Keys to setting up a good query:

• Select the fields in the sequence you want to report them
• Set the Order By for the correct sorting
• Make sure that fields that should be totaled are not included multiple times

Break and Group

Break and group work together to create the levels of a report. In many cases the break and group are set to the same value.

BREAK: Each new value, starting with 1, triggers a new level of the report to be created.
GROUP: Causes the selected field to group with the fields that break at the same level.

Menu Keys

As of version 2.7.6, queries that are to be shown on the Custom Exports or Custom Reports menu may be configured to appear at the end of any Keystone menu section by specifying a "Menu Key" when saving the query. When a query is configured this way, an image appears next to the query description on the menu to indicate that the option is a custom query.

Here are some common Menu Key values:

Menu Key	Menu Section
APP_ACCT	Accounting
APP_AR	Billing & Accounts Receivable
APP_AP	Accounts Payable
APP_PO	Purchase Orders
APP_GL	General Ledger
APP_PR	Payroll
APP_JC	Job Cost
APP_CM	Cash Management
APP_QT	Quote System
APP_TI	Ticketing
APP_DI	Dispatch
APP_DO	Document Imaging
APP_UTIL	Utilities