ExecuteSavedSearch
5 min
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" docid\ u26v9fecfs6ilwa0 pvjd 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 yes¹ business rules initialization rules yes business rules read only rules yes business rules required rules yes¹ 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 (except when this field appears on a form or is triggered by such a field ) no 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 be extracted from savedsearch result return value array \[string] this function returns text (string) values only it does not support numeric comparisons if your saved search returns a number or integer, format it as a string or handle it using a separate logic path example the following is an example of using this function in a saved search to get a list of users who have not logged into the application this week, a usernotloggedinthisweek saved search can be created on the employee business object as shown below the usernotloggedinthisweek saved search uses the executesavedsearch system function to invoke the logged in this week saved search in the security history business object the $(executesavedsearch("frs ops logon history#", " logged in this week", "userid")) system function will return a list of userids by invoking the logged in this week saved search for the security history business object
