function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
V AnandV Anand 

can we use order by in subqueries?

In SOQL I want to display the contacts  details....

There is another custom object called "Tester". There is lookup relation between Tester and contact.

 

 my SOQL query is  


nlist=[select lastname,firstname,email,phone from contact where id in


(select contact__c from tester where name='abc' order by status__c) ]

 

I got  this error

 Compile Error: expecting a right parentheses, found 'order' at line 15 column 1

 

I have to display the contacts in soring order based on status__c value.

but this field belongs to the object of Tester.  

How can I achive this any suggestions.....

 

 

 

 

 

Saikishore Reddy AengareddySaikishore Reddy Aengareddy

Order clause is not supported in sub queries... instead of that why dont you just query on Tester object..someting like..

 

List<Tester__c> tList = new List<Tester__c>();

 

tList = [select contact__r.firstname, contact__r.lastname, contact__r.email, contact__r.phone from Tester__c where name = 'abc' order by Status__c];

V AnandV Anand

Thanks for your reply .... I have done what you mentioned but still I am getting this error....

 

Compile Error: Didn't understand relationship 'contact__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name.