Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to extract column sorting of %ZEN.tablePane with or without snapShot

Question
Jose Antonio Ca... · Apr 1, 2016

How to extract column sorting of %ZEN.tablePane with or without snapShot

Hi all,

I've been looking for a way to extract the sorting  from the  ^CacheTemp.zenData global that contain the tablePane snapshot data in order to use it on a report following the current UI sorting criteria.

I could see that if the column is sorted by one column, new entries with this structure are created:

^CacheTemp.zenData(<sessionId>,<snapShotId>,<tablePaneId>,"index",<columnId>,<value>,<dataId>)=""

These are created the first time that the sort criteria is applied (asc) and has the same amount of entries as the data being displayed. But then if I change the criteria to descentant this data dont change and then I cannot differ whether the sorting order.

 

Is there a way to get the data of the ^CacheTemp.zenData in the same sorting displayed on the page?

 

Best regars

#Caché #Code Snippet #ZEN

Source URL:https://community.intersystems.com/post/how-extract-column-sorting-zentablepane-or-without-snapshot