My Oracle Support Banner

E-QR: Cannot Use Wildcards In Composite Query Prompts (Doc ID 2388349.1)

Last updated on FEBRUARY 08, 2019

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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.