Creating a new query for an integrated report

Last Updated : Apr 30, 2015 |
Prolog information
  1. Select Query from the Edit menu.
    STEP RESULT:
    The Query Select window is displayed.
  2. Select New.
    STEP RESULT:
    A Query Assistant window is displayed. For more information, see Adding the database items and calculations for the SELECT portion of the query window.
  3. Select Database next to Integrated.
    STEP RESULT:
    The tables that are available for integrated reports are displayed.
  4. In the Table list, highlight the name of the table that includes the database items or calculations that you want to include in the query.
    ADDITIONAL INFORMATION:
    For integrated reports, you can select one table per query.
    For information on the database items and calculations available in each table, see the Avaya Call Management System Database Items and Calculations.
  5. Select Next.
    STEP RESULT:
    A Query Assistant window is displayed. For more information, see Adding the database items and calculations for the SELECT portion of the query window.
  6. In either the Database Items or Calculations box, highlight the first database item or calculation that you will reference in the query.
  7. Select Add.
    STEP RESULT:
    The item is listed in the Query Items box.
  8. Repeat Steps 6 and 7 until all of the database items and calculations that you believe will be referenced in the query are listed in the Query Items box.
  9. Select Next.
    STEP RESULT:
    A Query Assistant window is displayed.
  10. Select Input Start Time or Select Start Time Now.
  11. Do one of the following:
    ADDITIONAL INFORMATION:
    If you selected
    Then
    Input Start Time
    Define the time that the integrated data will always begin accumulating for this report.
    Select Start Time Now
    A Start Time field will be added to the report input window and users can individually define the time that data will begin accumulating for the report.
  12. Select Next.
    STEP RESULT:
    A Query Assistant window is displayed. On this window, you can choose the input item that will be used for the query.
  13. Highlight the inputs you want to use as criteria for the query. You can create a new input by selecting New Input, that takes you to the Edit Inputs assistant.
    ADDITIONAL INFORMATION:
    Only the inputs that apply to the table you selected for this query are displayed.
  14. Select Next.
    STEP RESULT:
    A Query Assistant window is displayed. On the Query Assistant: Select the input used to indicate the agent or split/skill for this query window, you can choose the input item that will be used for the query.
  15. In the Name text box, enter the name that you want to assign to the query you created.
  16. Select Done.