+ Start a Discussion

SOSQL reducing results

Does any know how to reduce the results of a search on a relationship that's not limit? I don't need to reduce the number of lines returned.

Select p.Doctor__c, p.Doctor__r.Name, p.Doctor__r.OwnerId, p.Name, (Select Description, Id From Tasks) from Patient__c p

It returns all doctors and any task. if there is no task it still returns the doctor. How do i get only doctors with tasks?

werewolf
That's a tough one. I don't think you'll be able to do this in a single query.

dgindy
Thanks...I guess i need to submit this request to the Ideas page

Need an account? Sign Up

Have an account? Sign In