Bookshelf Home | Contents | Index | Search | PDF |
Siebel Search Administration Guide > Siebel Search Configuration Using Siebel Tools > Advanced Configuration of Search Operations >
Using Search Filters in Filter Search Specs
At search time results can be constrained implicitly through a filter search spec. This is typically defined under Search Engine > Search Definition > Search Definition Category object.
For text fields an example of filter search spec is as follows. For the search category Literature in the Call Center Definition, to restrict literature search results implicitly, by the Sales Tool Type of Brochure, you may want to specify a filter search specification like the following: [Sales Tool Type]=LookupValue('SALES_TOOL_TYPE', 'Brochure').
For information on Search filter syntax, see Syntax For Filter Search Specifications.
For date fields, an example of filter search spec is as follows. For the "Auction End Date" filter field example, you could add the Filter Field to the search category Auction Item in the eSales Search Definition. For example, to restrict results to only those Auction Items whose End Date is less that today's date, you may want to specify a filter search specification as follows. [Auction End Date] <= Today().
NOTE: Hummingbird Search Server does not support indexing time fields, so if you index a datetime column the time part would be ignored.
Supported comparison operators are =, <>, <, >, <=, >. Other supported functions include the Today() function. You can also specify Today() + or - a certain number of days. For example, you could add the following to the Search Spec: [Auction End Date]<= Today() + 10. As always multiple filter search spec can be joined together by AND, OR, and NOT.
Table 21 lists search filter field object properties.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Search Administration Guide, Version 7.5, Rev A Published: 18 April 2003 |