You need to sign in to do that
Don't have an account?
Apex Data Loader 19 and aggregate query does not return the parent object fields
I want to count the Child (ChildTable__c) objects for each ParentTable.
I try to run the following aggregate query:
Select Count (Id), THAKA__ParentTable__c, THAKA__ParentTable__r.Name from THAKA__ChildTable__c group by THAKA__ParentTable__c, THAKA__ParentTable__r.Name
And export it on CSV. The THAKA__ParentTable__r.Name is blank. This happens only when I have an Agregate query.
When I run the following query:
Select Id, THAKA__ParentTable__c, THAKA__ParentTable__r.Name from THAKA__ChildTable__c
The field THAKA__ParentTable__r.Name has the Name of the parent object.
I even tried using the C# application (API) and the aggregate query returns the parent object fields.
Anyone has seen this problem?
I saw a similar issue with the Data Loader and gave up after hours of trying to figure out my problem. Let me know if you come up with a resolution!
Regards,
Thomas