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
Jennifer.SchnellJennifer.Schnell 

Find Open Opportunities by a list of Account ID numbers

I have a list of Accounts with IDs that just had an account owner change.  I need to find the ID's of all OPEN opportunities related (child) to that list of account ids and be able to expert both the account id and open opportunity id, Is this possible through the Developer Console or another tool?  I have Demand Tools also.
Best Answer chosen by Jennifer.Schnell
Raj VakatiRaj Vakati
How many accounts? I can say use some data extract tools like. 

https://dataloader.io/
https://workbench.developerforce.com/login.php


If you have bulk account id its difficult to see from the SOQL query. What I can suggest is extract the data into excel files by using those tools and perform the Vlookup .  

 

All Answers

Raj VakatiRaj Vakati
How many accounts? I can say use some data extract tools like. 

https://dataloader.io/
https://workbench.developerforce.com/login.php


If you have bulk account id its difficult to see from the SOQL query. What I can suggest is extract the data into excel files by using those tools and perform the Vlookup .  

 
This was selected as the best answer
Jennifer.SchnellJennifer.Schnell
Thanks @Raj!