Views:

Description

Finds a value in any field on any entity based on 1 or more search criteria. Note that the defaultvalue parameter is optional.

Find on the account entity the description property where the name equals Microsoft.

Signature

FindValue('entitylogicalname', 'inputfieldname', 'inputfieldvalue', 'outputfieldname','defaultvalue', 'nolock', 'cacheenabled')

Example

FindValue('account', 'name', 'Microsoft', 'description', 'Not Found', false) Returns 'Microsofts Dynamics CRM Rocks.'

You can also pass in parameters to the function

FindValue('account', 'name', [account.parentaccountname], 'description', 'Not Found') Returns 'North52 BPA Rocks.'

You can search based on multiple input parameters.

FindValue('account', SetFindAnd('name', 'accountnumber'), SetFindAnd('north52', 'Acc-100452'), 'description')

Note 1: By default the nolock parameter is set to false
Note 2: By default the cacheenabled parameter is set to true. When using formulas of type Process Genie it may be useful to set this parameter to false if you need to bypass the cache and go directly to the database each time it is invoked within the lifetime of the workflow.

Parameters

NameTypeDescriptionRequired
entitylogicalnamexxxxxxxxxxxx
inputfieldnamexxxxxxxxxxxx
inputfieldvaluexxxxxxxxxxxx
outputfieldnamexxxxxxxxxxxx
defaultvaluexxxxxxxxxxxx
nolockxxxxxxxxxxxx
cacheenabledxxxxxxxxxxxx

Notes: