Simple List Widget Filter

[Andrew114]

I am relatively new to ServiceNow so please forgive my ignorance. 

I have a requirement to make a list available on the service portal that shows all Major Incidents where the incident's parent location matches the current logged in user's parent location. I have tried to create this using the simple list widget but I am realizing that I cannot dotwalk to get information from the user's location record in the simple list widget's filter.  

Can someone please advise on the best way to accomplish this?

[raphaelcrv]

Hi Andrew, How are you?

So i think your problem is just filter, i recomend filter on the plataform:

Bellow follow the step by step:

1 - type yout table on search like this (sys_user.list)

2 - apply a filter as you need we have the dynamic as showing on the image bellow

3 - the trick is copy the query and apply on the widget

Apply the query on the simple list and everything will work!!

Good Luck,
I hope this solve your problem 🙂

[Vinay Mishra3 · Accepted solution]

Hi Andrew,

Write a script include function (Write your logic here) then return all the matching sys_is's, then open the list widget instance and in filter put sys_is is one of javascript:yourScriptIncludeName().functionname()

See the below snap for reference.

Please mark correct/helpful, If its applicable for you.

Thanks,

Vinay

[Andrew114]

This was just what I needed, thanks Vinay!

[Vinay Mishra3]

Please mark my answer Correct/Helpful, If it worked for you.

Thanks,

Vinay