Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SOQL Problem

Hello I am having problems with this query:
select workflow__r.serial_number__r.name, SUM(hours__c) from workflow_detail__c group by workflow__r.serial_number__r.name
When I run the query in force.com explorer the results are fine, but if I place it in an OPENQUERY function like this:
select * from OPENQUERY(SALESFORCE, 'select workflow__r.serial_number__r.name, SUM(hours__c) from workflow_detail__c group by workflow__r.serial_number__r.name')
It returns NULL for all the values of workflow__r.serial_number__r.name and does not appear to be doing the sum correctly but that is harder to tell with no other identifiers. Additionally if I remove the Group by clause and the sum(hours__c) part of the query the query works fine. Is this normal behaviour?
1 person has
this problem
+1
Reply