Diamond Data Query Tool
Modified on Thu, 03 May 2012 09:49 by tsanchez — Categorized as: User Interface
Table of Contents
[
Hide/Show
]
General Description
Fields/ Filters
General Description
¶
Default Menu Location
: Reports>> Diamond Data Queries
Screen Name
: SQLSELECT
Function
: The Diamond Data Query Tool is used to create and run SQL queries that are specific to a company's business process.
Click to enlarge screen shot
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.