Create a report where assigned to me but updated by someone else is displayed

[riskay123]

Hi there,

I have a favorite filter that shows all Active tickets that are assigned to me using Assigned to is dynamic and updated by is not me. This works really well for me being able to quickly jump on tickets that have a response from someone other than me.

I am building a dashboard for my team, and I would like to have a widget that displays a report with something similar. Can I build a report to display Active tickets that are assigned to me using Assigned to is dynamic and Updated by is not me but make that last bit dynamic too so it reflects the logged in user?

Thank you in advance 🙂

Is there an easy way to do this? 

[Aman Kumar S]

Hi @riskay123 

You can always try javascript: gs.getUserID()

Ref to snap below:

[riskay123]

Hi Aman

Thanks for your reply. I tried your suggestion but it did not work.

If I used your suggestion and popped it into Chat GPT and it said that I can't directly use JavaScript function in a filter conditions. Instead, I can create a script include that returns the current user's ID and then refence that script include in the filter condition. It does warn that script includes may have performance implications. So I am not sure if I should try this. I might try it on my PDI. Thanks for your reply anyway 🙂

[Aman Kumar S]

Hi @riskay123 

Its good that you are relying on ChatGPT for the advices on best practices, but it is totally alright to use the code that I have shared with you. And if you can find any reason/justification why not to use it that will be helpful.