I was facing issue while exporting the hierarchical portlet to excel sheet where Child rows were not getting exported.
But after going through this thread: https://support.ca.com/us/knowledge-base-articles.TEC530394.html
I implemented the query as mentioned. Now the child rows are getting exported but some rows are getting missed and some are wrongly grouped.
Please refer to the attached screenshot for export result.
Can anyone please help what could be the issue?
Is there any other way to resolve the issue or my implementation