I need to update a field from a text field to a yes/no field, as it was incorrectly set up initially. I set up a backend API workflow that looks for any text field containing “yes” and update the new field to “yes”, etc… it works great on my Dev site.
However, when I try and run this bulk API workflow on my live database, it tells me that it will only run this on 50000 rows. I have 60000 in total. Does this mean that I will only be able to partially run this bulk operation?
Is there a way to run a bulk query to modify all 60000 rows in the database? Would appreciate your advice on this.