How to create a report with dynamic "Contains"

Jeff Page1 · ‎01-22-2019

I would like to create a report that can be applied to a dashboard that shows (for the viewing user/current/active user) what they are watching.

Work notes list > contains > xxx

Watch list > contains > xxx

Both filter conditions only allow textual input. Other filter condition have a "is dynamic" condition that fills in a predefined item (assignment group > is (dynamic) > One of My Groups). Work Notes/Watch List seems to not have this feature. Is it possible to place some javascript in there? I gave it a try and came up with nothing; I am probably doing it wrong, however.

Or, maybe there is already a dashboard widget that does this and I merely overlooked it?

Any thought, pointers, or suggestions would be greatly appreciated.

Thank you.

Troy Riblett · ‎01-22-2019

Ah. I was just throwing it together really quickly in the listview since I mistakenly assumed they would be the same. My bad about that.

Unfortunately, I don't have a good way to do this.. So how about a bad way? 😃

First type "sys_report.list" into the filter navigator and hit enter.

Then locate your report and open it. Ignore its pleas that you use the report builder to edit and then change the filter as you want.

If you go into the report now it will display the filter.. kinda.. correctly. I don't recommend trying to update the report from report builder after you do this.

View solution in original post

Jeff Page1 · ‎01-23-2019

That worked great! Thank you very much Troy.