How to Enable Filtering for Calendar Report

[Zhiming Dai]

Hi,

Our team has created a calendar report displaying scheduled maintenance from our maintenance table. Recently we would like to add a filter so that the calendar can display maintenance events for the only group members effected.

There are over a hundred of possible members, so adding all of them to the style table of maintenance table so that group members display as an option in Highlight Based On menu is not an good approach. And the group member field in maintenance table was defined as List instead of Reference (because multiple users may be selected in forms), so our research on filtering the calendar with interactive filters in a Dashboard came to a dead end. 

So, are there any good workarounds to the issues we have? Any help would be appreciated!  

Thank you!

[Maik Skoddow]

Hi @Zhiming Dai 

to the best of my knowledge it is not possible to extend the calendar report. 

But there is another calendar functionality which allows developing calendar based applications with more flexibility. OOTB applications are using this too: https://docs.servicenow.com/bundle/paris-application-development/page/script/server-api/concept/c_Sc...

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

[Maik Skoddow]

Hi @Zhiming Dai 

yes you can create such a report with the help of a dashboard and interactive filters, based on assignment groups.

Please see the following article on how to do that https://pathwayscg.com/configuring-and-using-interactive-filters-on-homepages-and-dashboards/

The result could look like this:

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

[Maik Skoddow]

Hi @Zhiming Dai 

Did my reply answer your question?

If so, please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what you are still missing.

Kind regards
Maik

[Zhiming Dai]

Hi @Maik Skoddow 

Thank you for the help and information! We set up our assignment group a little differently (our assignment group contains users that shouldn't be included in the table we are working on).

But we do have a similar field called Member Set (each set contains different groups of users, like department) in the table from which we need to pull data for the calendar report. The Member Set in this table is a List instead of Reference, so that we can select multiple Member Set at a time. That was the reason why our research on using interactive filter came to a dead end, as using List in interactive filter was not supported. So I was wondering if there are any other workarounds?

Thank you,

Zhiming