Merge engine helps to merge and join data from various database tables to create a
single record. As this function may sometimes result in empty values in some records, default
values are defined for such records.
Required Editions
Available in Lightning Experience in Professional, Unlimited, and
Enterprise Editions that have Consumer Goods Cloud enabled.
The two types of default values that are defined are:
Constant values given as numbers,Booleans, or strings
Copy values also known as default presettings are given as "copy#<columnAlias>" and
refer to a column in the same result row where columnAlias names the column to copy
from.
For this functionality, facade method getMergedListAsync is extended by two new
parameters:
Both parameters are optional but if one of the parameters is defined, the second also must
be defined. These parameters are passed to the proxy and to the JavaScript ngmdba class. Here the parameters are converted to a single
parameter call workload.
Parameters
tableName: is the name of the table where merge
result must be stored
returnResult: A Boolean value- True or False.
Returns
result(promise): The API returns a promise. The
fulfilled promise contains the result as usual. If invalid input parameters are given,
the result is stored in the table but not returned.
Sample Code
getMergedListAsync: function (jsonQuery, tableName, returnResult) {
var id = Utils.log.LogUtil.startLog("Facade.getMergedListAsync", { "jsonQuery": jsonQuery });
if (!this.myProxy) {
LogUtil.error(id, "No proxy found!");
LogUtil.endLog(id);
return null;
}
Utils.log.LogUtil.endLog(id);
return this.myProxy.getMergedListAsync(jsonQuery, tableName, returnResult);
}
Did this article solve your issue?
Let us know so we can improve!
Loading
Salesforce Help | Article
Cookie Consent Manager
General Information
Required Cookies
Functional Cookies
Advertising Cookies
General Information
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.