Notifications

249 views

Description

Calendar report does not display all entries from date/time fields in Weekly calendar view.

Steps to Reproduce

 

  1. Create a new table and provide a value for Extends Table, for example, Table: u_availability_reservation.

    For more information, see the product documentation topic Create a table.

  2. Add two new Date/Time columns:

    • Column Label: Required Start
    • Column Label: Required End
  3. Add a new record in the availability reservations table.

  4. Right-click the form header and navigate to Configure > Form Layout.

  5. Add the Required Start and Required End columns to the form.

  6. Click Submit.

  7. Navigate to Reports > Create New and create a new Calendar report on the availability reservation [u_availability_reservation] table with the Calendar by field set to Required Start.

    For more information, see the product documentation topic Create a report.

  8. Click Run to run the report.

  9. Select the Month View and then navigate back to the March and April month views.

    You should see entries for period March 7 to April 16.

  10. Switch to the Week View and then navigate back to the March and April week views.

    You will see entries for period March 7 to April 10 only. The Weekly entry for Monday April 11 to Saturday April 16 is missing.

Workaround

To reduce overhead, the number of events returned when you browse the calendar back and forward in Day or Week or Month view is limited to30 days in the past, starting from the first day in the current Calendar view going back 30 days. You can change this limit by setting the value of the system property glide.report.calendar.max_days_back. For performance reasons, do not set this value to a large value so the report table does not contain too many records that need to be fetched every time you move a day or a week in the calendar.


Related Problem: PRB691496

Seen In

Helsinki
Helsinki Patch 0 Hot Fix 1

Fixed In

Istanbul

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-02 12:03:41
Published:2018-03-02