Top user actions - UserSession table or UserAction table?

Whether it’s the count of frustrated user actions or Top user actions, should we get it from usersession table or useraction table? Need some guidance on this. I see counts vastly differ for both.

In addition, I see another issue- Not sure if this is our company instance, but when I use the user session table, the where clause doesn’t work and pulls all the application names, whereas if I use the useraction table, my results are limited to the application name.

SELECT useraction.application, useraction.name, COUNT(*) FROM usersession WHERE useraction.application =“My_App” AND useraction.apdexCategory=“FRUSTRATED” GROUP BY useraction.application,useraction.name

vs

SELECT useraction.application, useraction.name, COUNT(*) FROM useraction WHERE useraction.application ="My_App" AND useraction.apdexCategory=“FRUSTRATED” GROUP BY useraction.application, useraction.name

Hi,

This is explained in the documentation of USQL how the filtering works for primary and secondary “tables” works: Custom queries, segmentation, and aggregation of session data in RUM Classic — Dynatrace Docs

Thanks! This explains it!