Salesforce - Drawloop Issue with row and table replication

  • 26 October 2016
  • 1 reply
  • 41 views

Hello!

 

I am going to try and explain this the best that I can. I have a client that wants to replicate child records, but not replicate a record if it shares the same address.

 

Example:

 

 

Child related list (Customer__c) has 4 records. 2 of the 4 records share the same company name and address. 

Tags on the form are as follows:

<<Company_Name>>

<<Company_Address>>

 

If I add a Table Replication tag in front of Company Name tag, all 4 records will repeat including the records that share an address. 

The requirement is to list each company with name and address, but records that share the same company name and address need to show up only one time.

 

Example of incorrect format:

 

Company A

1111 Street

Anywhere, US

 

Company B

2222 Road

Whatever, PA

 

Company C

333 Avenue

Huh, WA

 

Company C

333 Avenue

Huh, WA

 

Example of correct format:

Company A

1111 Street

Anywhere, US

 

Company B

2222 Road

Whatever, PA

 

Company C

333 Avenue

Huh, WA

 

Any ideas on how to accomplish this? If at all?

 

Thank you so much!

Shannon


1 reply

Hi

Apex Data type relationship is what you need,

You have to create a class that and remove duplicate via logic and pass that to drawloop.

IApexDataSource and ExternalData samples 

Download the sample and see opplineItemGrouping for reference

Reply