Defining HAVING Criteria


Concept


Steps:

  1. Begin by navigating to the Fields page.

     

    Click the Reporting Tools link.

    Step 1
  2. Click the Query Manager link.

    Step 2
  3. In this example, you will search for the PT_SEC_ACCESSLOG_USER query.

     

    Click in the begins with field.

    Step 3
  4. Enter the desired information into the begins with field. Enter

     a valid value
     e.g.
     "pt_sec"
    .

    Step 4
  5. Click the Search button.

    Step 5
  6. Click an entry in the Edit column.

    Step 6
  7. Use the Fields page to view how fields are selected for output; view the properties of each field; and change headings, order-by numbers, and aggregate values.

    Step 7
  8. Use the Edit button to display the Edit Field Properties page.

     

    In this example, you will edit the properties of the Client name/IP Address field.

     

    Click the Edit button.

    Step 8
  9. Use the Edit Field Properties page to format the query output.

    Step 9
  10. Click the Count option.

    Step 10
  11. Click the OK button.

    Step 11
  12. Click the Having tab.

    Step 12
  13. Use the Having page to add selection criteria (in the same way that you add selection criteria using the Criteria page.)

    Step 13
  14. In this example, you will add a new HAVING criteria.

     

    Click the Add HAVING Criteria button.

    Step 14
  15. The Edit Having Criteria Properties page is identical to the Edit Criteria Properties page except that when you select the field for Expression 1, Query Manager lists only the fields that are associated with an aggregate function on the Select a field page.

    Step 15
  16. Click the Choose Record and Field button.

    Step 16
  17. Click the Client name / IP Address link.

    Step 17
  18. Click the Condition Type list.

    Step 18
  19. Click the like list item.

    Step 19
  20. Click the Prompt option.

    Step 20
  21. Click the Select Prompt button.

    Step 21
  22. Click the User ID link.

    Step 22
  23. Click the OK button.

    Step 23
  24. Click the Save button.

    Step 24

You have successfully defined HAVING criteria.

Table of Contents  Start Topic