Bookshelf Home | Contents | Index | Search | PDF

Siebel Search Administration Guide > Syntax For Filter Search Specifications > Filter Search Spec Syntax >

Filter Search Specification

---

Assigning a search expression to an object definition's Search Specification property is similar to the predefined query's expression; however, identifying the business component and specifying the reserved word Search is not required.

NOTE:  The Search Specification expression must be on one line. If more than one line is used the search spec may not get processed correctly.

Examples of the Filter Search Specification

[Close Date] > "04/15/95"
[Sales Tool Type] LIKE "Cal*"
[Start Date] >= Today () AND [End Date] <= Today() + 100
[Solution Type] = LookupValue ("SOLUTION_TYPE", "Solution") AND ([Publish External] = "Y"
[PriceListId]=GetProfileAttr("DefaultPriceListId")

NOTE:  For date formats in filter Search Specification, use the business component format. To reference a field value, you must use [Filter Field Name]. Also, string constants must be enclosed in double quotation marks ("string").

In the preceding examples, the fields declared must exist within the designated search filter field object definition. Some special fields that can be used are the Id field.

Bookshelf Home | Contents | Index | Search | PDF