Siebel Search Administration Guide > Syntax for Filter Search Specifications > Filter Search Specification Syntax >

Functions in Calculation Expressions


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

Table 20. Functions That Can Be Used in Filter Search Specifications
Function
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 table 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 (in the format mm/dd/yy).

GetValidCatalogCategories()

String

Returns a list of valid catalog categories for the current logged in user.

Siebel Search Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.