Might be similar question is very popular & asked several times but if someone can suggest a way to achieve this by any way then it'd be very helpful.
What I want:
I want to have dump of worklist data for each user as we're going to send this data to another system for use.
(Example: if I query that final dump with where userid = 'xyzuser1' then it should be able to give me tasks for that user.)
Things to consider:
=> I'm using
- K2 Roles (dynamic also)
- AD-Groups in K2 Roles (optional - I'll find a workaround for this)
=> I'll refresh this data & get the latest dump at certain interval (let's say 10 minutes)
What I've tried:
I'm doing an SQL query. I tried with joining the K2 tables & it is giving me worklist data but only problem is with K2 Roles (dynamic). It gives me participant as role name instead of users.
This is where I'm stuck. I don't know how to get the role users (for dynamic roles only).
I really want to go for SQL query way if anyone can suggest solution.
There are some suggestions online that go for code approach but can anyone confirm if I can get dump of worklist data for ALL the users in my organization?