Help with a fixed query

[alexlazo]

Trying to write a fixed query to only show records in a table with a matching location to the user opening the table.

Here is what I have for my filter:

&sysparm_fixed_query=u_location=javascript:gs.myUserObject.getLocation()

This returns "All > Location = (empty)

Any ideas what I'm missing?

[Brad Tilton · Accepted solution]

Try this:

&sysparm_fixed_query=u_location=javascript:gs.getUser().getLocation()

[alexlazo]

Perfect! Thank you so much

[mukesharora]

And could you tell how can we use this "sysparm_fixed_query=active=true" in scripts ?

[gratziela]

Hi Brad,

Is there a way to use the sysparm_fiexed_query in a widget for Portal ?

Regards,