Unable to filter records based on user action for Web clock

Summary:

Hello all,

A report is required in BIP which will fetch location (e.g. work from home, client office etc. ) selected by user during web clock option.

However report is fetching all reasons listed instead of actual reason selected by the user during web clock.

for 1 employee for 1 date query is fetching all location (e.g. work from home, client office etc.) instead of actual location which was selected by the user.

Attaching the sql query .

Content (please ensure you mask any confidential information):

NA

Version (include the version you are using, if applicable):

24A

Code Snippet (add any code snippets that support your topic, if applicable):