Welcome Guest, you are in: <root>AFIweb • Login

Page History: Diamond Data Query Tool

Compare Page Revisions

2 1 0 Current 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Thu, 03 May 2012 09:42

Table of Contents [Hide/Show]    General Description    Fields/ Filters        Right Column

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 needed from the drop down menu, once the code is displayed in the grey box RUN the query

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

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

Right Column¶

P1: Prompt needed to correctly fill out query

V1: Variable/Answer to the prompt abover