How to count user actions with JavaScript parameters?

[mcordent]

Hi everyone,

I would like to chart the number of user actions according to a specific URL.

This url looks like: /eWavWeb/util/GetJSAudit.do?function=getJSON. (this is an Ajax call)

When i do select useraction.name from useraction where useraction.name like '*/eWavWeb/util/GetJSAudit.do*',

I only get /eWavWeb/util/GetJSAudit.do as useraction.name.

When I enter in session details. I can see details of the action, Xhr Request:

How can I get the number of request (or useraction) according to /eWavWeb/util/GetJSAudit.do?function=getJSON?

Thanks

[zietho · Accepted solution]

Hey,

have you tried using aggregate functions?

e.g.,: SELECT useraction.name, count(*) FROM useraction where useraction.name = "/api/products" group by useraction.name

gives you:

regards Thomas