Getting user actions for a given time with USQL

[mkulov]

Hi,

I want to get user actions for a given period of time - lets say for yesterday.

I am running the following query but I get no results:

SELECT name FROM useraction WHERE startTime < "2.09.2020"

When I set the date to be current date "3.09.2020" I am getting data as expected.

However no data is received for a given period of time other than the current date.

Any idea how to get user actions for a given period of time?

Thank you,

Martin

[AlexanderSommer · Accepted solution]

Have you adjusted the global time frame selector in the header?

[mkulov]

Hi Alexander,

Yes, it was the timeframe selector and I was also missing startTimestamp parameter for the API call.

Thanks for your help!

Martin