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¶

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.