Modifying and adding calendar report system properties

  • Release version: Yokohama
  • Updated January 30, 2025
  • 4 minutes to read

    • 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

    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.

    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

    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.

    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

    1. Add the glide.ui.date_format.first_day_of_week system property.
    2. Set one of the following integer values.
      OptionDescription
      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.
    3. 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.

    Customize calendar weeks

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

    Before you begin

    Role required: admin

    Procedure

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

    Before you begin

    Role required: admin.

    Procedure

    1. Add the glide.ui.max_calendar_records system property.
    2. Complete the form with the following values.
      OptionDescription
      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.