Bookshelf Home | Contents | Index | PDF |
Siebel Search Administration Guide > Configuring Siebel Search Using Siebel Tools > Using Search Filters in Filter Search SpecificationsAt search time results can be constrained implicitly through a filter search specification. This is typically defined under Search Engine > Search Definition > Search Definition Category object. For text fields an example of filter search specification is as follows: Consider the Search Category Literature in the Call Center Definition. To implicitly restrict search results on Literature to show only, for example, the Sales Tool Type of Brochure, you can specify a filter search specification like the following: [Sales Tool Type]=LookupValue('SALES_TOOL_TYPE', 'Brochure'). For more information, see Syntax for Filter Search Specifications. For date fields, an example of filter search specification 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 than today's date, you may want to specify a filter search specification as follows: [Auction End Date] <= Today(). NOTE: Hummingbird SearchServer 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 specification can be joined together by AND, OR, and NOT. Table 28 lists search filter field object properties. |
Siebel Search Administration Guide | Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |