> Defining SQL Select Statements for Inbox Entries and Key Performance Indicators

Define SQL select statements to query the Datastream 7i database for the status of inbox entries and KPIs. The SQL select statement must return one row with a quantity for an inbox entry and/or the current score for a KPI. For example, you create an inbox entry "Requisitions that require HenryG’s approval" with the following SQL select statement:

SELECT count (*) FROM r5requisitions WHERE req_dfltauth = ‘HENRYG’

  Datastream strongly discourages modifying installed queries.

Follow these steps to define SQL select statements for inbox entries and key performance indicators.

  1. Open the Select statement definition form (BMQUER).

  2. Click the Record view tab. Datastream 7i displays the Record view page.

  3. Code—Enter a unique code identifying the SQL select statement.

  4. SQL statement—Enter the SQL select statement for the inbox entry or KPI.

  5. KPI—Select to indicate that the SQL select statement is for a KPI.

  6. Inbox—Select to indicate that the SQL select statement is for an inbox entry.

  7. Choose File | Save from the menu bar. Datastream 7i saves the information to the database.

   Click Test SQL to verify the correct syntax of the SQL select statement.