USQL useraction filter not working as expected

fstekelenburg — Wed, 24 Mar 2021 23:37:27 GMT

I am trying to create a table of selected key user actions with a filter based on their name. However, whatever I try to use as filter on useraction.name, the result set contains more results than the desired selection. No matter if I use useraction.name IN, IS, =, STARTWITH or LIKE.

example:

SELECT useraction.name, AVG(useraction.visuallyCompleteTime) AS VCT FROM usersession WHERE useraction.application='APPNAME1' AND browserType='Desktop Browser' AND useraction.targetUrl STARTSWITH "https://my.site" AND useraction.name IN ("my - some page") GROUP BY useraction.name ORDER BY useraction.name DESC

Other selections that appear not to have a result are useraction.keyUserAction IS true and useraction.internalKeyUserActionId STARTSWITH "APPL"

Example of query result, with expected results in green box:

Re: USQL useraction filter not working as expected

fstekelenburg — Thu, 25 Mar 2021 13:10:02 GMT

Thanks to Collin of support I was pointed out that I needed to reverse my query, using useraction not usersession, and pull the session variables from usersession.<var>, thus:

SELECT useraction.name, AVG(usersession.visuallyCompleteTime) AS VCT FROM useraction WHERE useraction.application='APPNAME1' AND usersession.browserType='Desktop Browser' AND usersession.targetUrl STARTSWITH "https://my.site" AND useraction.name IN ("my - some page") GROUP BY useraction.name ORDER BY useraction.name DESC

topic Re: USQL useraction filter not working as expected in Dashboarding

USQL useraction filter not working as expected

Re: USQL useraction filter not working as expected