Org Chart Duplicates Data

[Albarosæ]

Hello,

I am trying to make an app about tasks and their relation. Also the reload times and status'.

But there is a problem about a relation I guess. You can see the image below:

What  I need is like below:

These are the same task and even the same taskID but it shows duplicated.

And here is the table for this task:

And here is the data model for the app:

Thanks.

[daturpin]

Looks like multiple entries in the table with the same task name. The entries are not identical, one is failed and one has a difference in the duration. SHOULD there be only one entry? And if so, would you like the newest entry to overwrite the older one with the same task name?

[Albarosæ · Accepted solution]

I think the problem was occured due to task's first reload before connecting it to a parent task. It finds that log and also counts that task. 

After making the relation of tasks and parent tasks with a mapping and order by desc, the problem has solved.

There could be another solution where we rename the root nodes with a prefix and remove all tasks that has no parent and dont have the prefix.

Thank you for your interest.