Mass update of the priority of many tasks at one time

I am running nextcloud 19.0.8 with postgres as the database backend. I’d like to run a SQL query to do a mass update of the priority of several hundred tasks. I have looked at the oc_calendarobjects_props table and found some of the task information stored there but could not find the priority of individual tasks.

Where is the task priorities stored? By the way, my task database has about 5000 tasks and I need to update over 700 of them, hence a SQL query would be the best.

1 Like