Service Manager

Home 

ExecuteSavedSearch

Returns result of a saved search for a particular field.

Syntax

ExecuteSavedSearch(tableRef, SavedSearchName, fieldName)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category Yes/No
Business Rules: Before-Save Rules Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load) Yes
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load) Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load) Yes
Business Rules: Editing Rules Yes1
Business Rules: Initialization Rules Yes
Business Rules: Read Only Rules No
Business Rules: Required Rules Yes1
Business Rules: Validation Rules Yes
Client Expressions No
Object Permissions No
Services Yes
LDAP Yes
Mobile Yes
Quick Actions (except UI Quick Actions) Yes
UI Quick Actions No
Reports Yes
Search/Dashboard without field references Yes
Search/Dashboard with field references No
1. Except when this field appears on a form or is triggered by such a field.

Parameters

tableRef

The business object whose SavedSearch needs to be evaluated.

SavedSearchName

The name of the SavedSearch.

fieldName

The name of the field, whose value has to extracted from SavedSearch result.

Return Value

Array [field datatype].

Example

The following is an example of using this function in a saved search.

Let’s say we want to get list of users who has not logged in into the application in this week. For that we can create a saved search UserNotLoggedInThisWeek on the Employee Business Object as depicted in the below images.

 

 

Note here that saved search UserNotLoggedInThisWeek uses system function ExecuetSavedSearch to invoke saved search Logged In this week present in Security History business object.

System function $(ExecuteSavedSearch("Frs_ops_logon_history#", " Logged In this week", "UserId")) will return a list of UserID by invoking saved search Logged In this Week for business object Security history.


Was this article useful?