Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - WebI - Using Wildcards for Pattern Matching in Query Conditions

This article explains how to use single and multiple character wildcards for pattern-matching in query conditions.

Wildcard Characters

Wildcards are special characters that denote any single character or any number of characters. When entering a pattern-match for a prompt (or a constant in the query), use the following wildcards:

  • _ (underscore) for any single character
  • % (percent sign) for any number of characters

Understanding the Single-character Wildcard

To look for the product categories of either SHIRTS or SKIRTS, use the pattern S_IRTS. This pattern specifies that the values retrieved must:

  • Be six characters long
  • Have S as the first character and IRTS as the final four

The _ means there can be a single unspecified character between the S and the IRTS.

Understanding the Multiple-character Wildcard

To look for any product category beginning with the letter B, use the pattern B%. This pattern specifies that the values retrieved must have B as the first character. The % means that the B can be followed by an unspecified number of characters.

Entering Wildcards for a Pattern-matching (contains) Prompt:

A report that uses a predefined pattern-matching condition will prompt you for either "...starting with" or "... contains". You can use wildcards in the text you enter for these prompts, but remember that the "...starting with" prompt will have a multi-character wildcard appended to the end and the "...contains" prompt will have the multi-character wildcard appended to both the start and end.

Creating a Query Filter With a Wildcard

You can use wildcards as placeholders for partial pattern searches. When you create the query filter using a wildcard, you must use one of the following relational operators.

  • Matches pattern: to find values that match the pattern you specify
  • Different from pattern: to find values different than the pattern you specify

Apply Wildcards to Query Filters

  1. In the Query panel, drag the object you want to filter by into the Query Filters pane.

  2. Click the Operator Type drop-down arrow, and select Matches pattern from the list.

  3. Click the filter definition text box and type the wildcard pattern you want to use.

  4. When you have entered all of the query filters and result objects you need, click Run Query.

If you want to use multiple matches:

  1. Create the first query filter using the steps above.

  2. Click Add nested filter (at the far right on the query filters). This adds an OR nest in the query panel.

  3. Or Nest Created by Add Nested Filter Option

  4. Move the existing matching filter to the nest and then create a second matching filter in the nest (or move it to the nest)

    Two Matching Filter Nested with Or

The report results should reflect the wildcard you entered.

Keywords:Business_Objects, IRF, AURA, SDW, GEMS, Report, Financial, Payroll, data_provider, refresh, boolean, contains, ends_with, begins_with, filter, report, webi   Doc ID:17261
Owner:James I.Group:University of Chicago
Created:2011-03-09 19:00 CDTUpdated:2017-05-17 13:10 CDT
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  59   9