Interactive Filter "between dates"

Aka Guglielmo
ServiceNow Employee
ServiceNow Employee

Good morning all,

we would like to add a "between dates" interactive filter to an home page.

Like in list filtering:

date.png

Do you know if it's feasible and how?

Thanks

167 REPLIES 167

Ulrich Jugl
ServiceNow Employee
ServiceNow Employee

Hi William,



I don' think this is possible with the current implementation of Interactive Filters. What you could do is to add your "between dates" in the Business rule "Get Date Filter Options for Date Filters", so it will be shown in the setup of a new Date Interactive Filter. But this would imply that you know the between dates in advance I guess.



Cheers,


Ulrich


Hi Ulrich,

 

I know my dates in advance and i tried adding this line of code in Business rule to get the interactive filter working for custom dates. However, this does not seem to work. Any idea why?

 

answer.add('189_P05 2022@javascript:gs.dateGenerate(%272022-04-24%27%2C%2700:00:00%27)@javascript:gs.dateGenerate(%272022-05-21%27%2C%2723:59:59%27))', gs.getMessage('P05 2022'));

julian_mills
ServiceNow Employee
ServiceNow Employee

Adding paultannerrice to the discussion.


pieter_goris
ServiceNow Employee
ServiceNow Employee

Hi William,



you could create your own custom interactive filter (Custom interactive filters ).



To give you a head start, please find attached an update set that will create


-a new widget type ("Custom Interactive Filters") in which you can list for which dates you want to have interactive filters


and  


-a UI macro ("interactive_date_filter") that will generate the interactive filters as listed within the new widget type.



The result in the UI looks like this:


ServiceNow 2016-11-10 14-38-55.png


So like when in the condition builder, you can select:


-the date (A) to use in the filter,


-the operator (B) to apply,


-the operands (C) to set. The operands are of course dependent on the operator selected.



When developing or troubleshooting interactive filters, consider to add the "Debug homepage filters" (D) on your dashboard.



You could also have an interactive filter for which the date is fixed, so a user is not troubled by selecting the right date. It looks like:


ServiceNow 2016-11-10 14-49-48.png


Now, the user can only select the operator and operands.



To add the custom interactive filters to a dashboard when using the attached update set, it will look like this (with the responsive canvas plugin in Helsinki turned on):


ServiceNow 2016-11-10 14-53-59.png


So a new type/category of widgets (E), showing the dates as listed (F) in the new widget types.




In the new widget type ("Custom Interactive Filters"), you can list multiple dates for which you want interactive filters available in a 'condition builder' look and feel. It looks like this for the two interactive filters from screenshot above:


Custom Interactive Filters _ ServiceNow 2016-11-10 15-00-51.png


Thus


-give an interactive filter a name (1). This will show up on the widget;


-define the table (2). And if you want the user to be able to select for which date the filter should work (first screenshot), don't specify a field;


-define a specific field from the table (3) if you don't want the user to be able to select a date.



If you don't want every user to be able to add custom interactive filters to a dashboard, set the roles that should have access (4).



You can add more interactive filter dates to the list. For example:


Custom Interactive Filters _ ServiceNow 2016-11-10 15-26-32.png


resulting in:


ServiceNow 2016-11-10 15-28-07.png



Hope this helps.



Cheers, Pieter