User Session Query Language - example

[Romanenkov_Alex]

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

[David_Hauger · Accepted solution]

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

[Romanenkov_Alex]

i changed userId to usersession.userId and it works.

Thank you.

[David_Hauger]

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