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
force shahidforce shahid 

SOQL query for list of opportunities without open activities ?

Hi Friends,

I need one query  for list of opportunities without open activities . Is there any possibility for getting result without writing any code ? I need only one single query . 

Thanks in advance.
Shahid.


 
Waqar Hussain SFWaqar Hussain SF
Hi Shahid,

You can use below query to fetch all opportunity with open tasks. 
Select Id, Name, (Select Id, Subject from Tasks where IsClosed= false) from opportunity

 
force shahidforce shahid
Hi Hussain,
I need opportunities without tasks & events .