Having

This article provides information regarding the Having Page in the Query Manager.

Detailed Information

The Having page in Query Manager allows us to filter the output using the aggregate function. It is similar to the Criteria page, but it is used for aggregate columns. You must have an aggregated field if you want to use it, such as COUNT, SUM, MIN, or MA

Example

Find institutions that have more than 5000 students
     Showing a visual example of the Having Aggregate.

Similarly, when you filter the aggregates field, the field will be added under the ‘Having’ tab automatically.

Showing the location of the Having Tab.

  1. Create an aggregate field. In this case, COUNT(A.EMPLID) was created in the expression as enrollment field. (Please see the Creating Expressions page for more information about expressions.)

    showing the Edit Expression Properties Window with a COUNT Expression entered.
  2. Click the small funnel icon for the expression
    Showing the query manager screen with the Add Criteria icon (funnel with a plus sign) highlighted.
  3. Change Condition Type to "greater than" and enter the constant. Click OK
      showing the Edit Having Criteria Properites screen with the condition of "greater than 5000 constant" being set.
  4. When you go to the Having page, the criteria is automatically added on the page (not on the Criteria page).
    Showing the location of the having tab with the newly created condition showing.
  5. Run the query to check the data

Join the PS Query Group!

Have you joined UMS PS Query User Group yet?You can ask questions or share tips and more.

Environment

  • PeopleSoft Campus Solutions (CSPRD) 
  • PeopleSoft Campus Solutions Reporting (CSRPT)
  • PeopleSoft Human Resources (HRPRD)
  • PeopleSoft Financials (FNPRD)
Print Article