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
| Parameter | Description |
|---|---|
|
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.