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

dona2
Giga Contributor

Hi All,

This seems to be simple but for some reason the condition that I am setting up is not accepting the javascript: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: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!

 

dona2_1-1674006683670.png

 

Thank you

 

 

2 ACCEPTED SOLUTIONS

Basheer
Mega Sage

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

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"

 

Bidduam_0-1674023965418.png

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

9 REPLIES 9

Bidduam
Tera Guru

If it is to show what is assigned to the current logged in user that is running the report all you should need to do is use:

Bidduam_0-1674010790774.png

It will then dynamically treat "me" as the person logged in and running the report

dona2
Giga Contributor

Hi Bidduam,

Thank you .  Is the is(dynamic) is Me only applicable to the fields assigned to.  There are 3 key people in the record; assigned to, manager and business authorizer.  How about if the condition is if the business authorizer is the currently the logged on user just like the screenshot below. 

 

dona2_0-1674023359724.png

 

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"

 

Bidduam_0-1674023965418.png

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

 

dona2
Giga Contributor

Thank you Biddauam.  That worked.