topic Re: USQL - User sessions query - Filter based on computed value in Real User Monitoring

USQL - User sessions query - Filter based on computed value

kmahali — Mon, 11 May 2026 01:22:54 GMT

SELECT usersession.startTime, userevent.startTime , usersession.userSessionId, usersession.stringProperties.user_loginid, (userevent.startTime - usersession.startTime )/60000 AS error_occurrence FROM userevent WHERE page = '/error_page' AND error_occurrence > 5

The above query would not work; it shows error 'Unknown field: error_occurrence'. Is there any other option to achieve this?

Re: USQL - User sessions query - Filter based on computed value

Khejazi — Mon, 11 May 2026 08:30:51 GMT

Hi,

Unfortunately, you can't use Alias in Where clause, you can use only fields.

Re: USQL - User sessions query - Filter based on computed value

kmahali — Mon, 11 May 2026 11:26:48 GMT

Thanks Khejazi, for your reply.

`AND (userevent.startTime - usersession.startTime )/60000 > 5`
Even with the fields arithmetic is not allowed. Is there any workaround for this?

Re: USQL - User sessions query - Filter based on computed value

Khejazi — Mon, 11 May 2026 11:55:07 GMT

It will be the same since you are using an expression which is not originally a field in the table