Creating a new query for an integrated report

Last Updated : Apr 30, 2015 |

Procedure

  1. Select Query from the Edit menu.

    The Query Select window is displayed.

  2. Select New.

    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.

    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.

    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.

    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.

    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.

    A Query Assistant window is displayed.

  10. Select Input Start Time or Select Start Time Now.
  11. Do one of the following:

    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.

    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.

    Only the inputs that apply to the table you selected for this query are displayed.

  14. Select Next.

    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.