Filtering the Request (My Tickets) to only the caller and any open work orders in their location

[Rhonda9]

Hello,

I am trying to modify the MY Tickets Widget filter to only show open work orders that belong to the opened_by  and the opened_by location.    So if a user creates a work order , I want them to see their own work orders including any open work order in there specific location.     I have not been able to accomplish this. I need assistance please . 

 I have attached a screenshot.

This is what I have and its showing me all open work orders from the user in the caller field of the work order. I need to see all work orders from the user's location too.

active=true^caller= javascript:gs.getUser()

Thanking you in advance

[Manmohan K]

Hi @Rhonda9 

Add below filter 

active=true^caller=javascript: gs.getUserID()^ORlocation=javascript: gs.getUser().getRecord().getValue('location');

[Rhonda9]

Thank  you for your response but the filter is not working.  There is no work orders showing now.

[Manmohan K]

@Rhonda9 

Can you validate if there is location field on work order table and what is its backend name

Also can you share image of filter applied

[Rhonda9]

The actual name for the work order table is "location"