Loading
Mail Delivery Issue Impacting Email to Salesforce UsersRead More
Visual Studio Code Based Modeler for Consumer Goods Cloud
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          getMergedListAsync(datasourceInfos, [tableName, returnResult])

          getMergedListAsync(datasourceInfos, [tableName, returnResult])

          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:

          Facade.getMergedListAsync(datasourceInfos, [tableName, returnResult])

          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);
          }
           
          Loading
          Salesforce Help | Article