Views:

Description

Loads an xCache collection from an existing collection with a supplied filter.

Signature

xCacheFilterLocal('key', 'filter', 'sort')

Example-1

xCacheFilterLocal('AllAccounts', 'address1_country = "USA" ', 'address1_city')


Filters the EntityCollection called 'AllAccounts' so that it returns only rows matching address1_country equal to USA. And sorts the EntityCollection by address1_city


 

Example-2

xCacheFilterLocal('AllOpportunities', 'new_budget_amount > 10000 and new_optionset_rating  = 217000001', 'createdon DESC')


Filters the EntityCollection called 'AllOpportunities' so that it returns only rows that have a new_budget_amount greater than 10000 and field new_optionset_rating matches to a specific value.In addition it sorts the EntityCollection by creadedon field in descending order.


 

Parameters

Name Type Description Required
key xxxx xxxx xxxx
filter xxxx xxxx xxxx
sort xxxx xxxx xxxx

Notes: