Bookshelf Home | Contents | Index | Search | PDF

Siebel Marketing Guide > Defining Filter and Segment Criteria > Building a Criteria-Based Segment >

Using Wildcard Searches for Segment Attributes and Fields

---

Using the Edit Segment's Attribute Search and Field Search functions, you can perform a wildcard search for fields or attribute level values with certain characteristics, without having to manually select individual values in the Attributes or Fields tree lists.

For example, you might want to select states whose name begins with the letter A. Using the Attributes tree pane, you might expand the folders to reach state values, and then choose individual states such as Alabama and Alaska. Using Attribute Search, you might select the state values folder, and specify search criteria of A* to automatically select qualifying states. Because you are not selecting values individually, no values appear for the attributes or fields in the Attributes Search or Fields Search lists.

Valid search characters are asterisk (*) and the number symbol (#).

An asterisk (*) in the search pattern results in a match containing more than one character in the value.

If the search value is City=C*, the search returns Charleston, Columbia, Chicago, and so on.

A number sign (#) in the search pattern results in a match containing exactly one character in the value.

If the search value is VALUE=M#Y, the search returns MAY, MEY, MeY.

Search pattern values are case sensitive, for example, V* will produce different results than v*.
A combination of * and # can be used in the search pattern, but only when using the equal (=) operator.

Table 51 shows an example of wildcard results when searching for a State field in a Customers table.

Table 51.  Wildcard Search for Attribute and Field Values

Customers.State (values)	Wildcard Search = V*(result)	Wildcard Search = V# (result)	Wildcard Search VALUE= V*a
Virginia, VA, VT, Vermont, MD, Utah	Virginia, VA, VT, Vermont	VA, VT	Virginia

To perform a wildcard search for attributes

From the application-level menu, choose View > Site Map > Segments.
In the All Segments list, create a segment record and save it.
In the All Segments list, select the segment and click the Edit Segment view tab.

The segment form appears with the Attributes and Criteria panes in the lower half of the view.

In the Attributes tree pane, select Attribute Search from the drop-down list.

The view refreshes and the Wild Card Search entry field appears.

In the Wild Card Search field, type your search criteria.
In the Attributes tree pane, expand the folders to display values, and select the attribute level you want to find.
Click Add.

The attribute, including the search criteria is moved to the Criteria workspace.

When you have finished defining your segment criteria, click Validate & Save.

To perform a wildcard search for fields

From the application-level menu, choose View > Site Map > Segments.
In the All Segments list, create a segment record and save it.
In the All Segments list, select the segment and click the Edit Segment view tab.

The segment form appears with the Attributes and Criteria panes in the lower half of the view.

In the Attributes tree pane, select Field Search from the drop-down list.

The view refreshes and the Wild Card Search entry field appears along with the Fields tree list.

In the Wild Card Search field, type your search criteria.
In the Fields tree pane, expand the folders to display values, and select the check box for the field you want to find.
Click Add.

The field value, including the search criteria is moved to the Criteria workspace.

When you have finished defining your segment criteria, click Validate & Save.

Bookshelf Home | Contents | Index | Search | PDF