learn2power
Novice

SOQL query challenge

All, I have a query which works perfectly in workbench or developer console but does not seem to recognise in nintex docgen package SOQL query area under documents section. It says A query containing an inner query must have a Copy Type of Table.

 

Anyone know any resolution for this? How do I overcome this? Thanks

Labels: (1)
0 Kudos
Reply
1 Reply
Brent_Doc
Nintex Employee
Nintex Employee

Re: SOQL query challenge

Hi learn2power,

SOQL queries which are two levels ( Outer and Inner query) - will require the Copy Type "Table" from the "repeat by" dropdown.

This will replicate the outer query records as individual tables, and the inner query will row replicate in their respective parent record.

https://help.nintex.com/en-US/docgensf/DeliveryStorage/SOQLQueryRelationships.htm

https://help.nintex.com/en-US/docgen/docservices/#docgen-sfdc/Services/manageDDP/RelationshipSOQLQue...

0 Kudos
Reply