E-QR: Cannot Use Wildcards In Composite Query Prompts
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms