Grid Data Sort using QueryEntity

Hi,

I have a use case where I am fetching data from queryProcessAnalytics and a column inside that is having an primary key id, I want to sort the grid using that column. But the values are not in order in the DB for this table. So sorting happens for primary key. The report is also not supporting the queryEntity rule to fetch the correct value in the report itself, neither I am able to give the queryEntity in the field parameter of the gridTextColumn.

FYI- The id is of reference data added in DB.

Please propose a solution for the same.

 

Thanks

Ekansh Jain

Parents
  • Hi Ekansh,
    Yes todataSubset() will help and if you want to sort grid based on one particular column then give field parameter value in that particular gridTextColumn and you can remove field parameter value from other gridTextColumn if you don't want sorting based on other columns of the grid. Hope this was helpful.
    Regards,
    Teejesvi
  •  Yes correct I am applying the field parameter value in that particular gridTextColumn but the values I am getting from report is Id and want to sort using that value of id.
    Attached a screen shot that can explain better, here c11 is a column that has id coming from the pv in process, and I want the value of it from DB to sort the column. Currently if i do sort then it does sorting in the form of id's not value of that id.

Reply
  •  Yes correct I am applying the field parameter value in that particular gridTextColumn but the values I am getting from report is Id and want to sort using that value of id.
    Attached a screen shot that can explain better, here c11 is a column that has id coming from the pv in process, and I want the value of it from DB to sort the column. Currently if i do sort then it does sorting in the form of id's not value of that id.

Children

 Discussion posts and replies are publicly visible