Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

!PU(table) url option not working unless col option is added #142

Open
TechShady opened this issue Feb 18, 2022 · 1 comment
Open

!PU(table) url option not working unless col option is added #142

TechShady opened this issue Feb 18, 2022 · 1 comment

Comments

@TechShady
Copy link

!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.

@abdelmohssen
Copy link

Still same issue even-though you add col attribute, but it works when you click to column headers to sort.

Regards
Abdelmohsen

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants