Skip to main content
Nintex Community Menu Bar

Drawloop - Null / Blank values inherit first records data when SOQL and dot notation

  • March 26, 2021
  • 0 replies
  • 107 views

Brent_Doc
Nintex Employee
Forum|alt.badge.img+12

Issue

Replicating a SOQL relationship that contains a dot notation field - will inherit the first record's information if the dot notation record field is Null.
 

Error Code

 

Replicating a SOQL relationship that contains a dot notation field - will inherit the first record's information if the dot notation record field is Null.

Resolution

 

Only resolutions

1. Create a salesforce formula field to pull the data down a level. - then reference that field

2. Reorder the relationship so the Null values are first

3. Apex data relationship

 

Additional Information

 

 

Related Links