How to group schedules based on task data ?

[sujinsr]

Hi, Thanks for the good library.
I am planning to use db-scheduler in my project. I have a use case to display the created schedules in my web interface with grouping based on user who created the schedule.

I didn't find any option in the library address this requirement.

I am planning do custom HTTP API with below steps to meet the requirement,

• add new column user in scheduled_tasks
• create database trigger that will update the user column by parsing task_data. while creating schedule user added in task data
• GET HTTP on scheduled_tasks with query filter

Could you review this approach and provide feedback ? If any other out of the box approach please share the details.

Thanks.

[kagkarlsson]

What about using a JSONB type for the task_data, and just extracting the user from there via your select? (currently not sure what is required to use JSONB, but shouldn't be too hard.