SOQL query challenge

  • 13 January 2022
  • 3 replies
  • 228 views

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


3 replies

Userlevel 2
Badge +9
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/RelationshipSOQLQuery.htm

Hi @Brent_Doc Thanks for this. 


Do you know how this can be done as I am trying to bring sub child from a child which is linked to a parent? Hope it makes sense from the picture attached?

Userlevel 2
Badge +9

Hi @learn2power 


 


Yes, This will be possible. The WHERE clause is where you will enter the lookup field from the Child to the Parent and bring in the record id from the field tagger. Example below:


 


SELECT Id, Name, (SELECT Id, Email FROM GrandChildobject) FROM Childobject WHERE Starting(parent)Object.id = <<Record_Id>>

Then the Grandchild will Row replicate the record in the ChildObject Tables. The WHERE clause will give you only records from the specific parent record you ran from. 


 


Hope that helps! let us know

Reply