Hi team, I have a use case where I need to create tasks for users, but there is a parent-child relationship between tasks. In one interface, I will collect the details of the task, and users can add additional tasks to an already existing task. So, a parent task will have N number of child/related tasks, which will be stored in a table called "task details". Daily, once I trigger a process, it will query the task details and create the tasks. The thing I need is for the parent task to be created first, followed by related tasks in the order the user gave them. It would be simple to achieve this using a subprocess and looping the task creation by sorting the data using datetime. However, I wish to use the startprocess MNI, as it won't affect performance and to avoid instances paused by errors (subprocess will stop in this case). I don't know how to order the data or loop the data to achieve this. Any suggestions?
Thanks in advance
Stefan Helzle
Harshit Bumb (Appyzie) Mike Schmitt
Discussion posts and replies are publicly visible
I would like to understand the purpose of this parent-to-many children task concept first. Are these child tasks really tasks, with their own due date, escalations, exceptions and life-cycle? Or is this more like a to-do list for the parent task?
Yes Stefan they are real tasks. Now I found a solution. In the table I will have a column that holds the relationship between parent-child ( like a foreign key). By using that I can identify whether it is a Parent or child. another one Boolean column I can identify task is created or not. If I trigger a startprocess MNI, all instances will execute at the same time, so using these I can control the task creation, once parent task is created the column will become true, so that child can proceed, until that time it will wait (few seconds)