function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Test Test 143Test Test 143 

store result of Database.QueryLocator in List in BatchApex

Hi All,

As Part of my BatchApex Development, I need to store result of Database.QueryLocator in List.

Database.QueryLocator abc = Database.getQueryLocator('Query');
store ids in list by iterating abc
And need to use that list in,
  • Return Database.getQueryLocator ('Query in : abc(ids)');
Thanks!
AnkaiahAnkaiah (Salesforce Developers) 
Hi,

you can try like below in the start method. 
String query = 'SELECT Id,Name FROM Account';
        return Database.getQueryLocator(query);

If this helps, Please mark it as best answer.

Thanks!!
Test Test 143Test Test 143
Hi Ankaiah,

Thanks for your time and help!

I am sorry for confusion.

In start method of batchapex,
global list<task> tasks=new list<task>();
    global Database.QueryLocator start(Database.BatchableContext BC){
list<id> tasks=new list<id>();
 Database.QueryLocator tasking=Database.getQueryLocator('select  WHOID from task where conditions');
        for(task s: (list<task>)tasking){
                    tasks =s.id;

        }
       return Database.getQueryLocator('select id from Lead where  AND ID NOT IN : tasks');
}

Help me in above bold part.

Thanks!