E-QR: Cannot Use Wildcards In Composite Query Prompts
(Doc ID 2388349.1)
Last updated on MAY 04, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
For a Query, you can create a prompt that will work with a wildcard entry (such as "A%"), by creating a prompt with "no table edit" and setting the associated field criteria to use the "like" operator.
For Composite Query, when trying to follow the same method, for the "like" operator on the filter it only allows you to set it for a constant and not a prompt. This means that you can only do a hard-coded wildcard and doesn't allow for specifying one at runtime.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!