Skip to main content
Nintex Community Menu Bar

Here is my SOQL:

SELECT Id,Cross_Section__r.Name,(SELECT Id FROM Cross_Section__r) FROM SAS_Product_Type__c

Here is the error:

Cross_Section__r.Name,(SELECT Id FROM Cross_Section__r) FROM SAS_Product_Type__c
                                      ^
ERROR at Row:1:Column:49
duplicate field selected: Cross_Section__r

Looks like the Child Relationship Name of Cross_Section__r and its parent object of SAS_Product_Type__c and the Lookup field of Cross_Section__c on SAS_Product_Type__c are being flagged as duplicates.

The Cross_Section__r child records is where we record each section of a cross section on the SAS_Product_Type__c with lengths and angles, whereas the Cross_Section__c lookup is to the File object for attaching an image of the cross section.

I found a post about without and answer. So I answered it. 😃

a10d0a976b1a74ea923656a86a084365f427b070.pngSalesforce Developers Forums 1f55b0e5bbac6d294cf8800934faaf17379aa0f9.png

DeveloperForce

Wow good catch, sounds like a frustrating bug.