Using Substr and expressions to find partial matches in PeopleSoft Financial Query

How to use partial matches in PeopleSoft Financials Query for use as a field or criteria.

Solution:

Example public query SAB_PROJECT_LOG_ALL

Query

On the Query tab, expand the record for CU_PG_TOT_AWARD and select the field CU_PG_ACCT_NUM.

PeopleSoft Query Tab
 

Choose Expression tab, Click Add New Expression.  Choose Character, length 3, in Expression text paste in substr(D.CU_PG_ACCT_NUM,4,3)

PeopleSoft Add Expression Text
 

Click OK, then click Use as Field:

PeopleSoft use as Field selection

To change the column heading name, Click on the Fields Tab, then go to the bottom of the list of fields and choose Edit.  Choose Text and then type a new header (make sure to leave Unique Field Name as is).

 PeopleSoft Change column  heading name

 

 If you have more questions about this, email ITHELP@clemson.edu or call 864-656-3494.

Attached Files
There are no attachments for this article.
Related Articles RSS Feed