Hello Community,
We are noticing a discrepancy between the actions visible in the User Session timeline and the results returned from querying the userAction table.
Session contains the following visible events related to /en/home:
Load → loading of page /en/home
Page change → /en/home
From the session timeline, the total visible /en/home actions are 10.
However, when querying userAction, we are getting lower counts.
Query #1:
SELECT count(*)
FROM userAction
WHERE (
targetUrl LIKE "%/en/home%"
OR name = "loading of page /en/home"
)
AND application = "xxxxxx"
AND usersession.internalUserId = "xxxxxxxx"Result: 7
Query #2:
SELECT count(*)
FROM userAction
WHERE (
name = "loading of page /en/home"
OR name = "/en/home"
)
AND application = "web.vodafone.com.eg"
AND usersession.internalUserId = "1778209989302OEJ4PVDRSB0PUEKFR0E6D2UP2S867H2M"Result: 4
It seems that some “Page change” events visible in the session timeline are not queryable from the userAction table.
Has anyone faced similar behavior before?
Is there a recommended way to retrieve all visible session timeline actions (including Page change events) through queries?
Thanks.
Aboud
Featured Posts
