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

Functions in Calculation Expressions


Functions that can be used in the filter search specification are listed in Table 36.

Table 36.  Functions that May be Used in Filter Search Specs
Character
Purpose
Example
GetProfileAttr ("[Attribute]")
String
Returns the value stored in the profile attribute if that attribute has been defined. Used in personalization to retrieve values of attributes in a user profile and to pass information from a script to the UI. Set a session-specific personalization attribute equal to the value of the shared global and reference the personalization attribute in a calculated field.
NOTE: for an undefined attribute or for an attribute that has not been set up, GetProfileAttr returns NULL. Search Server does not support NULL values in the query.
LookupValue (type, lang_ind_code)
String
Finds a row in S_LST_OF_VAL where the TYPE column matches the type argument, the CODE column matches the lang_ind_code argument, and the LANG_ID column matches the language code of the currently active language. Returns the display value (the VAL column) for the row. This function is used to obtain the translation of the specified untranslated value in the specified LOV into the currently active language.
Today
Date
Today's date (for example, 6/30/02).
GetValidCatalogCategories()
String
Returns a list of valid catalog categories for the current logged in user.


 Siebel Search Administration Guide 
 Published: 19 June 2003