+ Start a Discussion
thakathaka 

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?

Thomas StrohThomas Stroh

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