Difference between revisions of "Diamond Data Queries"

Latest revision as of 13:40, 6 December 2022

General Description

Default Menu Location: Reports>> Diamond Data Queries

URL: Diamond_S.htm

Function: The Diamond Data Query Tool is used to create and run SQL queries that are specific to a company's business process.

Fields/ Filters

Select the query from the drop-down menu, fill out any required variables, and click the RUN button. Then click EXPORT to save the results to an Excel spreadsheet.

Run: Will process the query and display live results in the grid below

Export: Will export the answer grid to an xls file.

Please Note: You must fill out the variables on the right-hand side of the screen if the query requires them.

Add New Diamond: Adds a new Diamond query

Edit Diamond: Allows user to edit Diamon query SQL statement

Save RS: Saves report set for future use

@@ Line 1: / Line 1: @@
+__NOTOC__
+===General Description===
+'''Default Menu Location''':  Reports>> Diamond Data Queries
+'''URL''':  Diamond_S.htm
+'''Function''':  The Diamond Data Query Tool is used to create and run SQL queries that are specific to a company's business process.
+[[image:diamond.png]]
+===Fields/ Filters===
+Select the query from the drop-down menu, fill out any required variables, and click the RUN button. Then click EXPORT to save the results to an Excel spreadsheet.
+'''Run:''' Will process the query and display live results in the grid below
+'''Export:''' Will export the answer grid to an xls file.
+Please Note: You must fill out the variables on the right-hand side of the screen if the query requires them.
+'''Add New Diamond:''' Adds a new Diamond query
+'''Edit Diamond:''' Allows user to edit Diamon query SQL statement
+'''Save RS:''' Saves report set for future use
+[[category: User Interface]]