cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

User Session Query Language - example

Alexander_R_
Advisor

Hello,

Can anyone show to me example for such task:

I have action named "test" - key user action.

I need to get query to get value of (visuallyCompleteTime) for my action "test" for specific userid (test@test)

Thank you.

Regards,

Alexander


3 REPLIES 3

David_Hauger
Newcomer

You could use:

SELECT starttime, visuallyCompleteTime FROM useraction WHERE name = "name" AND usersession.userId = "test@test"

to get all the different values.

Or, if they are too much:

SELECT AVG(visuallyCompleteTime), MIN(visuallyCompleteTime), MAX(visuallyCompleteTime), COUNT(*) FROM useraction WHERE name = "name" AND usersession.userId = "test@test"

to get some statistics on the visuallyCompleteTime


i changed userId to usersession.userId and it works.

Thank you.


ah, yes, of course - updated it in the query