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
Can you provide some screen shot as well as ppm version
A possibility for missing rows may be related to handling filters in the NSQL and wrong grouping may be attributed to Sorting order. But again, nothing can be concluded without knowing your NSQL.