How to show a list of Change Requests assigned to a current user

dona2 · ‎01-17-2023

Hi All,

This seems to be simple but for some reason the condition that I am setting up is not accepting the javascript&colon;gs.getUserID(). I am trying to provide a report to the current logged on user that is assigned to him with the following conditions:

- Type is Deployment Set

- Phase is Promoted

- Assigned to is javascript&colon;gs.getUserID()

When I put the javascript, it does not stick and it is saying no matches found. There is no save button. Below is a screenshot. Help!

Thank you

Basheer · ‎01-17-2023

Hi @dona2 ,

You need to use is dynamic me filter to achieve this.

this filter will get the records for the logged in user irrespective of whoever has logged in.

Please hit like button if my suggestion has helped you in any way.
Please mark correct if my response has solved your query.

Cheers,
Mohammed Basheer Ahmed.

View solution in original post

Bidduam · ‎01-17-2023

I don't have a field of that name in my instance, however if the field is a referenced from the sys_user table then yes you should be able to use the is dynamic "me" option.

So in the first column choose the field "Business authoriser", then second column should be "is (dynamic)" and the final column is "me"

If that doesn't work I'd need to know more about the Business authorisor field and how it gets it values

View solution in original post

Basheer · ‎01-17-2023

Hi @dona2 ,

You need to use is dynamic me filter to achieve this.

this filter will get the records for the logged in user irrespective of whoever has logged in.

Please hit like button if my suggestion has helped you in any way.
Please mark correct if my response has solved your query.

Cheers,
Mohammed Basheer Ahmed.

Ankur Bawiskar · ‎01-17-2023

@dona2

try to dot walk to sysId and then use it

Business authorizer.SysId [IS] javascript&colon; gs.getUserID()

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

dona2 · ‎01-17-2023

Thank you. The dot walk also worked. I tried something similar

Business authorizer.UserId [IS] javascript&colon; gs.getUserID() and got same result as

Business authorizer [IS] dynamic Me. I ended up using the second solution because it is easier to understand configuration and the breadcrumbs of the filter spells out the name of the user. Using the javascript will not show the name but the sys id of the user, which i still need to verify the user table to know who that person is.

Noth solutions work. Thank you!

kalyan13 · ‎01-17-2023

Hi @dona2 ,

Did you got the solution for this if not please let me know.

Regards,
Kalyan

dona2 · ‎01-17-2023

Yes I did Kalyan. Thank you