• thaka
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

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?

  • June 29, 2010
  • Like
  • 0