Vlocity Facts #28|| How to use QUERY() function in DataRaptors, Set Values with static and dynamic values

We can use SOQL in QUERY() function to fetch the details in DataRaptors or Set Values.

1. Static Value -- We can write query on recordtype by using formula tab in DataRaptor.

In the above screenshot by using Query function I'm getting recordtype id from Formula Result Path we can use that for mapping in out put tab.

2. Dynamic Value -- For example we need to pass any values to the query which we are getting from other actions or based on other record then we can follow this approach.

Here I'm passing Account Id, Priority  to get related case numbers of the account. 

QUERY("SELECT CaseNumber FROM Case WHERE Priority = '{0}'AND AccountId = '{1}' 
LIMIT 3", Priority, Case:AccountId)

Priority = '{0}' -- This holds the Account Priority in our case it holds 'Medium'
AccountId = '{1}'-- This holds the accountId
{0}, {1} holds the values of what we are mentioning after query in our example --
Priority, Case:AccountId

If there is requirement to query on date field don't use single quotes '' in where
condition.
QUERY("SELECT CaseNumber FROM Case WHERE ClosedDate = {0} AND AccountId = '{1}' 
LIMIT 1", Date, Case:AccountId)




 

Comments

Post a Comment

Popular posts from this blog

Vlocity Facts #01 | OmniStudio DataRaptors

DataRaptor is a mapping tool that  you can use to read, transform, and write Salesforce data. For Example. In each interaction with a digital customer  or business process, the system needs to extract the data in order to display it. If the user modifies this data or enters new data, they also need to be saved. This is where we use OmniStudio DataRaptors.  Where to use DataRaptors? Retrieving Data:   OmniScript calls  DataRaptor Extract (via the integration procedure) to read the data from Salesforce. For example, OmniScript editing an account should display data such as account name, phone number, website, and so on. Manipulating data: OmniScript captures modified and new data based on user input. For example, an agent changes the  phone number of an account. Save Data:   OmniScript calls DataRaptor Load (via the integration procedure) to write the data back to Salesforce. For example, the updated account phone number is saved back to the Account rec...
Read more

Vlocity Facts #34 || Getting the details from the URL in a FlexCard and an Omniscript

Image
 1.The parameters in the URL must be in the format c__Node, followed by their values, in order to extract the parameters from the URL. For example: If you need to show different layout or different set of actions for community users and salesforces users you can pass different parameters in URL. For Community Portal Pass Community or any other reference value in ' c__Type '. https://salesforce.lightning.force.com/lightning/cmp/ omnistudio__vlocityLWCOmniWrapper?c__target=c%3ApHXTestFlexCard&c__tabIcon=custom%3Acustom18& c__Type =Community  For Salesforce Users Pass Salesforce or any other reference value in ' c__Type '. https://salesforce.lightning.force.com/lightning/cmp/ omnistudio__vlocityLWCOmniWrapper?c__target=c%3ApHXTestFlexCard&c__tabIcon=custom%3Acustom18& c__Type =Salesforce  2. We can get the value as {Params.c__Parameter} from the FlexCard and we can execute different actions based on the input. 3. From the omniscript,  we can retrieve ...
Read more

Vlocity Facts #44 || Communication between Omniscript and Flexcard [Pub/Sub]

Image
Flexcards have the ability to trigger and listen to two kinds of events: Custom and Pubsub events . Custom Events: Facilitate the transmission of information between a child and its parent. This can occur between a child Flexcard and its parent Flexcard, or between an element and the Flexcard to which it belongs. Pubsub Events: Allows communication between two separate components. This could occur between two separate Flexcards on the same Lightning page, known as sibling Flexcards, or between a Flexcard and an Omniscript.  In this post I will discuss about Pub/Sub event. Consider we have omniscript and flexcard individually on home page when an update happens we need to show those details in flexcard. To achieve this we can use pub/sub event. Step 1: Create a omniscript according to your requirement. I'm trying to create Contact record by using Step element and data raptor post action. Now to trigger the flexcard we need to configure the messaging frame work when an update happen...
Read more