Adding "event to display" to list for calendar report

[pbostian]

OK schedule gurus...

I have created a new schedule on cmn_schedule for a Desktop Project Calendar.  Created new report on cmn_schedule_span where the schedule is that particular schedule, and added that to a dashboard.   The cmn_schedule_span table has the start and end time set correctly, but I cannot set the Start time in the report to show multiple day events... The only options in the "event to Display" dropdown only shows Created and Updated.  I need to see "start time" in order for it to display the event itself, not the start time.

Any ideas?  what am I missing?

[Naveen20]

The "Event to display" dropdown only lists Created and Updated because start_date_time and end_date_time on cmn_schedule_span are of type Schedule Date/Time (stored as varchar), not a true glide_date_time. Calendar reports only pick up standard date/datetime fields, so the span fields are filtered out — this is platform behavior, not a misconfiguration.

For rendering true multi-day spans of a schedule, use a Schedule Page (cmn_schedule_page) with the Calendar view rather than a Calendar Report. Point it at the same cmn_schedule record (Desktop Project Schedule). It natively understands repeat rules, all-day flags, and the actual span start/end, and can be embedded on a dashboard via a UI Page / Content Block.

If a report-style widget is mandatory, the other option is a custom Service Portal / UX widget that queries cmn_schedule_span directly.

Related community thread https://www.servicenow.com/community/itsm-forum/how-to-create-calendar-report-on-blackout-schedules-...

[Tanushree Maiti]

Hi @pbostian 

Refer:

timezone and date/time format of cmn_schedule_span 

What is the correct method to query Schedule Date/time fields in cmn_schedule_span? 

How to create entry in "cmn_schedule_span" table through script.