I am using queryEntityData SAIL tag to retrieve the data from database and calli

@ramakg - What you can do is after you have gathered all data from the db using apply, you can merge all the data using what we call an Anonymous CDT which is of type dictionary and then change it into a datasubset using todatasubset() function.
We do it for reporting because if the data comes from different tables then it is hard to sort. So we create a Anonymous CDT and merge then to one datasubset and the use it in a grid. Please make sure to use constant paginginfo throughout or else there might be some paging or sorting problem.

For example:
todatasubset(
\t{
\t firstName:"Sidhant",
\t lastName:"Behura",
\t gender: "Male",
\t age:"24"
\t}
)

Hope this information was helpful.

@ramakg - What you can do is after you have gathered all data from the db using apply, you can merge all the data using what we call an Anonymous CDT which is of type dictionary and then change it into a datasubset using todatasubset() function.
We do it for reporting because if the data comes from different tables then it is hard to sort. So we create a Anonymous CDT and merge then to one datasubset and the use it in a grid. Please make sure to use constant paginginfo throughout or else there might be some paging or sorting problem.

For example:
todatasubset(
\t{
\t firstName:"Sidhant",
\t lastName:"Behura",
\t gender: "Male",
\t age:"24"
\t}
)

Hope this information was helpful.