Chanson: /* Introduction */

2023-07-17T16:26:46Z

Introduction

← Older revision		Revision as of 16:26, 17 July 2023
Line 2:		Line 2:

	== Introduction ==		== Introduction ==
	~~[[Image:AR Query Export 0.jpg\|right\|thumb\|200px\|Query Export: Report List Screen]]~~

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

Line 14:		Line 12:

	See Also: [[Most Excellent Queries]]		See Also: [[Most Excellent Queries]]


	== Update Queries ==		== Update Queries ==

WikiAdmin: 1 revision imported

2023-07-14T13:00:35Z

1 revision imported

← Older revision	Revision as of 13:00, 14 July 2023
(No difference)

Intra>User: 1 revision imported

2017-01-10T00:02:11Z

1 revision imported

New page

[[Category: SQL]]

== Introduction ==
[[Image:AR Query Export 0.jpg|right|thumb|200px|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.<BR>
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:

{| border="3" cellspacing="0" cellpadding="3"
! 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
|}

Query Export - Revision history

Chanson: /* Introduction */

WikiAdmin: 1 revision imported

Intra>User: 1 revision imported