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
     

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

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.)
   
   
2. Click the small funnel icon for the expression
   
3. Change Condition Type to "greater than" and enter the constant. Click OK
     
4. When you go to the Having page, the criteria is automatically added on the page (not on the Criteria page).
   
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)