Currently I'm using DDP to merge few objects like Account,Opportunity,one custom object and Opportunity line item.
While creating relationship under DDP object as a "sql" I'm getting repetitive value(same) for different product. For eg.
There are two accounts "Account A" and "Account B"
Opportunity associated with Account A is having few line items (line item A, Line Item B, Line Item C)
Line Item is having lookup relationship with Account i.e one line item can associate to different Account.
"line item A" is associate with "Account A".
"line item B" is associated with "Account A"
"Line Item C" is associated with "Account B".
I want to show data of oppline item on document which i used to send through DDP as
Organisation Name :Account A
Product Info : line item A total of field1, line item A field 2
line item B total of field1, line item B field 2
Organisation Name : Account B
Product Info : Line Item C total of field 1, Line Item C field 2
Does the SOQL query pull in the correct data when you test it in the Developer Console? If not, you will need to rewrite the query to pull in the correct data.
While running SOQL query on console i'm getting records but on document I didn't get any value. In DDP relation ship I choose soql query and copy type as Table. Please suggest.
If no data is appearing in the document this may be due to an issue with the field tags. I recommend reaching out to our support team to review the field tags and document configuration.