!PU(table):url=/ui/user-sessions/${userid} doesn't make the column userid linkable. If I add in the col option, it works.
So !PU(table):col=-3;url=/ui/user-sessions/${userid} works.
The issue I'm running into is sorting. Here's my basic query...
SELECT userid,useraction.name as "User Action Name",useraction.visuallycompletetime as "User Action Visually Complete" FROM usersession WHERE ORDER BY useraction.visuallycompletetime DESC
I get results like this (just showing the last column):
[17,772, 58,434, 271, 0, 1,674, 1,716, 0, 0] ms
[0, 1,306, 0, 0, 36,223] ms
USQL is sorting it correctly as it will look in each row for the highest VC time and sort based off of that. This is exactly how I want my table data to be sorted. The only way I can get the url link to work is by adding the col sort option. That option will then sort each row as if the value is a character string and messes up my sort order.
!PU(table):url=/ui/user-sessions/${userid} doesn't make the column userid linkable. If I add in the col option, it works.
So !PU(table):col=-3;url=/ui/user-sessions/${userid} works.
The issue I'm running into is sorting. Here's my basic query...
SELECT userid,useraction.name as "User Action Name",useraction.visuallycompletetime as "User Action Visually Complete" FROM usersession WHERE ORDER BY useraction.visuallycompletetime DESC
I get results like this (just showing the last column):
[17,772, 58,434, 271, 0, 1,674, 1,716, 0, 0] ms [0, 1,306, 0, 0, 36,223] ms
USQL is sorting it correctly as it will look in each row for the highest VC time and sort based off of that. This is exactly how I want my table data to be sorted. The only way I can get the url link to work is by adding the col sort option. That option will then sort each row as if the value is a character string and messes up my sort order.