PeopleSoft Query provides the Having page, to enable you to add criteria on the aggregate instead of on the field generating the aggregate. The HAVING criteria appear in the HAVING clause of a SQL statement.

 

For example, you can use HAVING criteria to create a list of the departments that have a minimum salary greater than $100,000.

 

You can add the criteria from the Fields page, and then the system populates Expression 1 of the HAVING criteria. You do not have to access the Having page or the Edit Having Criteria Properties page.

 

In this topic, you will define HAVING criteria.


Table of Contents