Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Prompt Wild Card

Status
Not open for further replies.

Jembo

MIS
Dec 20, 2004
38
GB
Is it possible to use a 'wild card' in a query prompt?
For example, rather than select a Name from the Values list and get data just for that Name, enter a wild card to retrieve data for all Names.
 
From the BO User Guide "Accessing Data and Data Analysis..."

Using wildcard characters
Conditions with the Match pattern and Different from pattern operators are great
for finding lists of similar values, such as customer names beginning with S.
Wildcards are special characters that can denote any single character, or any
number of characters. BusinessObjects supports the standard wildcard
characters, which are:

% Replaces several characters, or in the
response to a prompt. For example, N%
returns all values beginning with an N (New
York, Nevada)

_ Replaces a single character in a constant. For
example, GR_VE returns Grave, Grove,
Greve.
 
Cheers for that.
I found the answer after I posted. I was getting no results because I was using 'Equal To' instead of 'Matches Pattern'.
(Heavy week and my brain has gone soft)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top