Skip to Main Content
Forums

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Quey with prompt unentered

Kel_123May 6 2014 — edited May 6 2014

Anyone have had this need before ? We have a query with 2 prompts ( BUSINESS_UNIT & DEPTID ) We have situations where users would enter only (a) BUSINESS_UNIT and (b) no DEPTID and they want to have the query selecting (a) only the BUSINESS_UNIT entered and (b) all DEPTID ( since user did not enter any DEPTID ) And same nature as they would like more prompts such VENDOR_ID, etc. Any idea or workaround you might have ? THanks

Comments

BobLilly

Sounds a lot like new query features described in the PT 8.54 Release Value Proposition (optional prompts and default values for prompts). See Oracle's PeopleSoft PeopleTools 8.54 Release Value Proposition (Doc ID 1664634.1) for more information.

Within Query Manager, you could use a Like criteria with a prompt, but then you couldn't use a prompt table. For example, the DEPTID criteria would be DEPTID LIKE :1, and if the user wants all departments they enter % as the prompt value. You could also use more sophisticated criteria, such as

('Y' = :1 or DEPTID=:2)

and use something like the PSYESNO field for the :1 prompt with heading text such as "All Departments". You would need to group the criteria using brackets due to the 'or' condition. The prompt would dispay as

All Departments: []  (a checkbox)

Deptid:  _______

If you use a prompt table for the deptid prompt, though, the user would still have to select a valid deptid even if they checked the All Departments checkbox.

Of course, building a custom component is always an option.

Regards,

Bob

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 3 2014
Added on May 6 2014
#peoplesoft-general-discussion
1 comment
97 views