Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Dynamic conditions on reports

reganr
Tera Contributor

Hello,

 

I would like to make a report once and use it across  orgainztions in my company.

I would like for the condition/filter on the organization to be selectable by the user instead of hard coded in the report...

At this point I have to create the same report for each orgainzation where I hard code the organization in each report.  If I ever have to make a change I have to then adjust every report for the one change...

Maybe there is something I dont know?

4 REPLIES 4

Michael Ritchie
ServiceNow Employee
ServiceNow Employee

Is the organization an attribute of the logged in user's sys_user record?   If so you can leverage that as part of the conditions on the report.


Just another follow up, if you own Performance Analytics Premium, there is a feature called interactive filters that you can use:


Interactive Filters



A solution I created a few years ago could be a solution for you as well:


Interactive Homepages


Ashby
ServiceNow Employee
ServiceNow Employee

Regan,


You can set an attribute to be dynamic in the condition builder.     As an example, I am referencing the incident table and created a report that will only display incidents that are assigned to a group the user is a member of.       If the attribute is not set to be dynamic, you can create a dynamic filter as needed.....so you can move away from hard coding your reports.      



Hope this helps...


Ashby  


find_real_file.png


find_real_file.png


reganr
Tera Contributor

Hello John,



yes I have seen that, but not in this case:


Untitled.png


most likely because I am using a dot walked field...