How to create a report with dynamic "Contains"

[Jeff Page1]

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.

[Coleton]

Are there other elements of the record which would work as identifying info for the user signed in? I would suggest avoiding any reporting off of journal fields/text fields since there isn't an inherent way to dynamically filter based off the 'Me' option (Unless you're in London).

The 'is (dynamic)' option appears for reference fields. If you were looking at a reference field, you could say:

<Reference_Field> 'Contains' javascript:var si = new customScriptInclude(); si.functionName()...

Here's some documentation explaining my above approach.

But that won't work in this case as these are plain-text/journal boxes.

[Troy Riblett]

It looks like on London that "is dynamic" is an option that already exists.

The other option is to put the following in a contains query

javascript:gs.getUserID()

An example of both options is below

[Jeff Page1]

Alright, you got me, I did not specify my version. I believe we are on Kingston.

And that is the java piece i tried, but it may not like that in Kingston.

Also, are you in Classic report builder?

[Troy Riblett · Accepted solution]

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.