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.

시작하기 전에

Role required: admin

이 태스크 정보

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.

주:

Calendar highlighting only applies to Core UI reports, not to Platform Analytics experience data visualizations.

프로시저

1. In the filter navigator, enter: sys_properties.list
2. Select 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.
3. Click Update.

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.

시작하기 전에

Role required: report_admin, admin.

이 태스크 정보

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

프로시저

1. In the navigation filter, enter sys_properties.list.
2. Configure the glide.report.calendar.max_events_displayed_per_cell and glide.report.calendar.max_more_events_per_day properties.
3. Click Update.

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.

시작하기 전에

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.

주:

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.

프로시저

1. Add the glide.ui.date_format.first_day_of_week system property.
2. 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

   주:

   Only Sunday and Monday are explicitly supported.
3. Click Submit.

다음에 수행할 작업

Configure the system property glide.db.week_numbering to specify how weeks are calculated. For more information, see Customize calendar weeks.

Customize calendar weeks

Configure a system property to specify how calendar week numbers are determined.

시작하기 전에

Role required: admin

프로시저

1. Navigate to sys_properties.list.
2. Add the glide.db.week_numbering system property.
   For more information, see Add a system property.
3. 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.

4. 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.

시작하기 전에

Role required: admin.

프로시저

1. Add the glide.ui.max_calendar_records system property.
2. 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.

3. Click Submit.

관련 정보

• Add a system property