Good day
I would like to use the benefit of group by function but also want to keep the tree structure of the task. Is it possible?
More details from the image can explain more about my question:
- I have two level tasks only (never need more than that). They need to be grouped by Job (project or similar term)
- In Job 6: Task 5,6 are sub level of Task 1 so I would like to have a tree node on task 1 where its children belong to.
Thanks
bellow is the json data for the case
{"data":[{"id":5,"text":"Task 2","start_date":"15/07/2018 00:00","duration":50,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-15T00:00:00","sortOrder":10,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":2,"jobName":"Job 3","priority":0,"status":0},{"id":7,"text":"Task 4","start_date":"29/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-29T00:00:00","sortOrder":11,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":6,"jobName":"Job 2","priority":0,"status":0},{"id":6,"text":"Task 3","start_date":"13/07/2018 00:00","duration":37,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-13T00:00:00","sortOrder":12,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":8,"jobName":"Job 5","priority":0,"status":0},{"id":4,"text":"taks 1","start_date":"09/07/2018 04:00","duration":9,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-09T04:00:00","sortOrder":23,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":3,"status":0},{"id":8,"text":"Task 5","start_date":"21/07/2018 00:00","duration":2,"progress":0.00,"parent":"4","type":"0","open":true,"dateObject":"2018-07-21T00:00:00","sortOrder":24,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":9,"text":"Task 6","start_date":"09/07/2018 00:00","duration":5,"progress":0.00,"parent":"4","type":"0","open":true,"dateObject":"2018-07-09T00:00:00","sortOrder":27,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":10,"text":"Task 7","start_date":"28/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-28T00:00:00","sortOrder":28,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":11,"text":"Task 8","start_date":"11/07/2018 00:00","duration":3,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-11T00:00:00","sortOrder":29,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":12,"text":"Task 9","start_date":"23/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-23T00:00:00","sortOrder":39,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":13,"text":"Task 10","start_date":"10/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-10T00:00:00","sortOrder":41,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":14,"text":"Task 11","start_date":"26/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-26T00:00:00","sortOrder":43,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":15,"text":"Task 12","start_date":"13/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-13T00:00:00","sortOrder":44,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":16,"text":"Task 13","start_date":"18/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-18T00:00:00","sortOrder":46,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":17,"text":"Task 14","start_date":"18/07/2018 00:00","duration":4,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-18T00:00:00","sortOrder":51,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":18,"text":"Task 15","start_date":"12/07/2018 00:00","duration":2,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-12T00:00:00","sortOrder":63,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":20,"text":"Task 16","start_date":"24/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-24T00:00:00","sortOrder":66,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":21,"text":"Task 17","start_date":"16/07/2018 00:00","duration":4,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-16T00:00:00","sortOrder":67,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":22,"text":"Task 18","start_date":"20/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-20T00:00:00","sortOrder":71,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0},{"id":19,"text":"Task 23","start_date":"18/07/2018 00:00","duration":1,"progress":0.00,"parent":"","type":"0","open":true,"dateObject":"2018-07-18T00:00:00","sortOrder":72,"target":null,"teamLeader":"Tran Hoang Anh","teamLeaderId":108,"jobId":10,"jobName":"Job 6","priority":0,"status":0}],"links":[],"collections":{"jobId":[{"key":2,"label":"Job 3"},{"key":6,"label":"Job 2"},{"key":8,"label":"Job 5"},{"key":10,"label":"Job 6"}],"teamLeaderId":[{"key":53,"label":"Lance Parker"},{"key":6,"label":"152HQ 152HQ"},{"key":61,"label":"Karen Parker"},{"key":63,"label":"Nidhin Joseph"},{"key":108,"label":"Tran Hoang Anh"},{"key":340,"label":"Sri S"},{"key":341,"label":"Sri G S"},{"key":342,"label":"TH Anh"}]}}