Filters on Schedule page

MikkelJ — Mon, 13 Jan 2025 16:26:11 GMT

Hi Everyone,

I have made a Schedule page to display Releases [rm_release], Changes [change_request], and Freeze periods [cmn_schedule] in one single calendar. There is no relationship between the task table, which rm_release and change_request are extended from, and cmn_schedule, which is why this solution has been necessary. The Schedule page has been invoked into a UI Page, which has been put into a Widget so the client can use the calendar in a dashboard. This is working as intended.

At the moment, Normal and Emergency changes are displayed, but Standard Changes are not shown. The client has requested the following:

A filter that allows the user to add Standard changes to the calendar. As the calendar is used in a widget, this needs to be coded on the Schedule page. I know this should be coded in the HTML script and Server AJAX processor, but I am unsure if a client script is also necessary. Additionally, it would be a great help to get some assistance with coding this. Specifically, I am unsure where to instantiate the variable that determines whether Standard changes should be displayed or not.
The client wants a choice list filter that filters Releases and Changes based on Area. It is possible to dot-walk from a Release/Change to Area via Release/Change --> Application [cmdb_ci_appl] --> Approval group [sys_user_group] --> Area [cmn_department]. I am quite sure that I need to report on the task table that extends the Release and Change table rather than show data from each table. Would you agree and how can this be achieved?
When there are more than 5 entries for a day, the record should display "+ x amount". For instance, if there are a total of 8 entries for a day, it should list 5 of them and write "+3," just like the Calendar report from ServiceNow does. How can this be achieved?

I have attached a picture of the Schedule page. Also, if anybody knows whether its possible to make a datbase view based on the task table, and the cmn_schedule, which extends from sys_metadata, please let me know.

question Filters on Schedule page in Community Central forum

Filters on Schedule page