Modifying and adding calendar report system properties
Specify system property values to override Task table highlighting in calendar events, limit the number of events in a calendar cell, or change the day the calendar week starts.
Override Task table field styles for highlighting calendar events
Highlighting for calendar report events is configured with field styles, which are defined for a particular table. You can configure whether calendar reports use field styles from the tables or report sources that they are based on.
Before you begin
Role required: admin
About this task
By default, field styles in the Task [task] table are applied to calendar reports. If calendar reports are configured to use field styles from their tables or report sources, these field styles override the Task table styles.
Note: Calendar highlighting only applies to Core UI reports, not to Platform Analytics experience data visualizations.
Procedure
In the filter navigator, enter:
sys_properties.listSelect the glide.ui.report.extend_calendar_choices property to specify which field styles are used during calendar highlighting.
- If
false, calendar reports will use only styles from the Task table when determining options for calendar highlighting. For example, a calendar report on the Change Request [change_request] table will only use styles from the Task [task] table instead of styles from a the combination of the two tables. - If
True, calendar reports will use field styles from the table that the calendar report is based on. - Click Update.
- If
Related topics
Limit the number of events displayed on calendar days
In calendar reports, you can configure the maximum number of events that appear in some calendar views.
Before you begin
Role required: report_admin, admin.
About this task
When the maximum number of events is exceeded, a + <number> link appears, which opens a pop-up window with additional events. You can also configure the maximum number of events that appear in this pop-up window. When this maximum is exceeded, a + many link appears, which opens a list of events instead of a pop-up window.
You can configure these settings for the following calendar views:
- A calendar day when calendar is in month or year view
- The top 'full day' section of a calendar day when a calendar is in day or week view
Procedure
In the navigation filter, enter
sys_properties.list.Configure the glide.report.calendar.max_events_displayed_per_cell and glide.report.calendar.max_more_events_per_day properties.
Click Update.
Related topics
Change the day that calendar weeks start on
By default, weeks for calendar reports start on Sunday. You can add a system property to start weeks on Sunday or another day instead.
Before you begin
Role required: admin
The glide.ui.date_format.first_day_of_week system property modifies the generated date/time value used in the query and sets the start day of the week in the rendered calender.
Note:
glide.ui.filter.first_day_of_week must also be set to the same value as glide.ui.date_format.first_day_of_week for the set day to display properly.
If you change the glide.ui.filter.first_day_of_week property after collecting Performance Analytics score data, you won't be able to view the scores for weekly indicators. To access them, you must collect scores again.
Procedure
Add the glide.ui.date_format.first_day_of_week system property.
Set one of the following integer values.
| Start weeks on Sunday | Set Value to 1 |
| Start weeks on Monday | Set Value to 2 |
| Start weeks on Tuesday | Set Value to 3 |
| Start weeks on Wednesday | Set Value to 4 |
| Start weeks on Thursday | Set Value to 5 |
| Start weeks on Friday | Set Value to 6 |
| Start weeks on Saturday | Set Value to 7 |
**Note:** Only Sunday and Monday are explicitly supported.
- Click Submit.
What to do next
Configure the system property glide.db.week_numbering to specify how weeks are calculated. For more information, see Customize calendar weeks.
Related topics
Customize calendar weeks
Configure a system property to specify how calendar week numbers are determined.
Before you begin
Role required: admin
Procedure
Navigate to
sys_properties.list.Add the glide.db.week_numbering system property.
For more information, see Add a system property.
Set one of the following string values.
| iso_week | Week 1 is the week with January 4, the first business day, or the first Thursday in it. \(These are mutually equivalent.\) There is no Week 00. |
| sunday_week | Week 1 is the week with the first Sunday of the year. Days before it are in Week 0. |
| monday_week | Week 1 is the week with the first Monday of the year. Days before it are in Week 0. |
| jan1_week | Week 1 is Jan 1-7; the next seven days are week 2, and so on. |
- Select Submit.
Set calendar record limit
By default, calendar reports save up to 10,000 records. Change this limit by setting the glide.ui.max_calendar_records system property. If the number of records fetched exceeds this limit, you are prompted to filter the data and run the report again.
Before you begin
Role required: admin.
Procedure
Add the glide.ui.max_calendar_records system property.
Complete the form with the following values.
| Name | glide.ui.max_calendar_records |
| Description | Enter a phrase that describes the function of the property, such as `Maximum number of calendar records saved`. |
| Type | Integer |
| Value | Enter the desired value for the number of records retained by the platform. The default value if this property is not configured is 10,000. |
- Click Submit.
Related topics