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...