Create Report for Followed Tickets

[Gary Snyder1]

Hi All,

I'm trying to create a report for my director who wishes to see tickets that he is "Following".  I tried searching the forum here and found a previous request for this from 2017, however that did not work for me.

Looking to be able to create this report to place on their Dashboard, as just a list of tickets.  Any assistance is appreciated!  Currently running Vancouver, if that helps.  Will be updating to Washington DC soon.

Thank you!

[Jaspal Singh]

Hi Gary,

Check for solution from thread. Should still hold validity.

[Gary Snyder1]

That seems to work for the most part, but I can't seem to get the "Created By" field to be dynamic (based on the logged in user).  If I manually enter a username here, it will work, but I need it to be dynamic and can't seem to get that part working.  I only have an "Is" declaration when using "Created By", not "Is (dynamic) like I have on fields in the Incident table (that I use for other reports).

Thanks!

[Jrobles91]

Using the table "live_group_member" might be the solution. Add the column "State" and those appearing as "Admin" are going to be the ones your director is currently following.

[Gary Snyder1]

Unfortunately, I am running into the same issue as the live_group_profile table.  I can view "all" records, but cannot filter to just the logged in user.  I've tried setting "Created by" to "gs.getUserName()" and get no results.  I think it's taking the text at face value instead of recognizing that it's a script.  There isn't an option for "is" to become "is (dynamic)" as I've seen when using the Incident table.