Vlocity Facts #38 || DataMapper Extract - Filter Conditions and Functions

Data Mapper Extract is used to fetch the records from salesforce. We can extract multiple object records based on conditions and filters. Will discuss some scenarios in this post.

1. Consider when we need to extract all the accounts, we can use '$Vlocity.NULL' in filter condition to get all the accounts. 

Note: We need to pass the environment value in quote ['$Vlocity.Null']

2. By using Order By we can filter the records and we can use DESC or ASC. By default records will be displayed in Ascending order. To display in Descending order use  DESC in filter condition. 

Note: Give space between the filed name and DESC/ASC

3. By using Offset we can skip the first N numbers of records while we are extracting. Offset we can use in Pagination scenarios. For more details refer this DataRaptor Offset Filter.

Here I'm passing Skip as a variable in Offset, we can pass the number to skip.


4. We can fetch the contacts based on the Account fields in singe extract step with out creating multiple steps. Consider i need to extract Contacts which are related to Industry - Energy of Accounts.
Note: Use dot notation[.] for standard objects Account.Industry, for custom objects use __r. Order__r.Status.

5. By using And, OR filters we can extract the records based on the conditions. Consider this SOQL query.
Select Id,Name,Active__c,AnnualRevenue,Industry from Account Where (LastModifiedDate != TODAY OR Active__c ='Yes' ) AND (AnnualRevenue != null OR Industry ='Energy'). 
    a. We can build our Data Mapper Extract with same conditions. 
    b. Limitation of DR is we cannot use brackets directly so we need to follow in this way to get the                same out put.

We can we the query in the debug log. we found 11 records.
Same number of records we got in Data Export.

6. We can use functions in formulas tab to get the desired output. By using sum we can get the total amount of opportunities related to account.
While Mapping Total Amount formula filed I have selected 'Currency' as Data Type that's why in response '$' we are seeing -- it is depend upon the org settings.

7. In extract tab or formula tab to the right side we can see one check box --> 'Show all sObjects Fields'. we can enable that check box all fields which are related to that objects we will be displayed in json format and it will be easy for us in mapping or choosing the fields. 
In mapping from 6th point screenshot if you observe I have used to 2 objects and different paths
a. For Account object --> Account is the path
b. For Opportunity Object --> Account:Opportunity is the path
Both paths of Json will be displayed once we enable Show all sObjects Fields. 





 







 




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