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.

Symptoms

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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms