narrowizard opened a new issue, #6113: URL: https://github.com/apache/incubator-devlake/issues/6113
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened When trying to retrieve child tasks data from Zentao raw layer data, we found that the API(which is the source of raw table data) returns child tasks as an array property of the parent task, instead of a separate item for each child task. As a result, we are unable to effectively read the child tasks data from the raw layer table(eg: _raw_zentao_api_tasks) using the _raw_data_id from issues table. ### What do you expect to happen We expect the data in raw layer table match that in issues table one by one. So that when I looking for raw data of an issue via _raw_data_id of it, there are exactly exist on raw layer table. ### How to reproduce 1. Create a parent task in Zentao. 2. Create 2 sub tasks for the parent task. 3. Collect data from the zentao project. 4. Check data from issues table, there will be 3 records 5. Check data from raw layer table, there will only be 1 record, which has property called children of type array(contains the two sub tasks). 6. And all 3 issues refer to the same record in raw layer table. ### Anything else _No response_ ### Version v0.19 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
