To Apply ORDER BY in PeopleSoft QUERY

Posted on

Their would also be some good methods or any proper specific way to speciry ORDER BY in Peoplesoft Query, but the was I used once is given below…

1. Create Your Query Completely

2. Go to “Having” tab

3. Click on “Add Having Criteria”

4. Select “Expression” and click on “New Expression”

5. Enter 1 in Expression Text field and click “OK”

6. Also choose expression from downside box, and enter: “1 ORDER BY yourField”

This will work. See the View SQL tab to better understand what this method did to your query.


2 thoughts on “To Apply ORDER BY in PeopleSoft QUERY

    Charlie said:
    November 1, 2017 at 5:03 PM

    To appy an ORDER BY clause, go to the Fields tab, click the Reorder/Sort button, and enter numbers to indicate your sort order down the RIGHT-HAND column.

    ziaahmedshaikh responded:
    August 1, 2018 at 6:45 AM

    Thanks Charlie, but the version we were using had not this option. We had PT 8.49

Leave a Reply

Your email address will not be published. Required fields are marked *