20 Oct 2022 09:38 AM
Hi,
We want to extract the userid that have clicked on two useractions. These useractions must be appear consecutive.
I've read here
that Ordering is partially supported
How can we do to get this?
Thanks in advance.
Regards,
Elena.
Solved! Go to Solution.
20 Jan 2023 02:50 PM
@erh_inetum were you able to get a solution to this? This should be able to be completed by having the USQL select the User ID where the user actions are (Action1) and (Action2). Granted you might need to do some tweaking as this is very generic.
SELECT userId FROM usersession WHERE useraction.name IS "<ACTIONNAME>" AND useraction.name IS "<ACTIONNAME>"
23 Jan 2023 05:44 AM
Hi @ChadTurner . I'll test it and I'll tell you.
Thanks!