+ Start a Discussion
Rabbani sayyed 8Rabbani sayyed 8 

i have 50000 records, and in all the 50000 records there is a field called status, my req is, i want to change the status field that will happen to all 50000 records at a time ? how can i achieve this? any suggestions on this?

i have 50000 records, and in all the 50000 records there is a field called status, my req is, i want to change the status field that will happen to all 50000 records at a time ? how can i achieve this? any suggestions on this?
Coco_SdyneyCoco_Sdyney
possible solutions:
1. data loader to do mass update
2. if you want to change this field of all 50000 records to be a static value, for example 'Updated', a tricky way is, delete the old status field, and create a new one with default value 'Updated'
Eswar Prasad@Sfdc11Eswar Prasad@Sfdc11
HI Rabbani sayyed,
It is possible through batch apex,pls see below link we can get idea.
http://salesforce.stackexchange.com/questions/15954/using-batch-apex-on-millions-of-records

Hope this helps! Mark it as solution if this solves your problem.
Regards,
Eswar Prasad.