RTx::Calendar - Calendar view for RT ticket dates and custom fields
RTx::Calendar provides a calendar view to display tickets and reminders based on selected dates. Once the extension is installed, if you perform a ticket search using the Query Builder, you will see a new Calendar entry in the page menu. You can click that menu to see the calendar view of your search. A portlet is also available to add to any dashboard, including on the RT home page.
RTx::Calendar
Works with RT 5.
For older versions of RT, see the CHANGES file for compatible earlier versions.
perl Makefile.PL
make
make install
May need root permissions
Add this line:
Plugin('RTx::Calendar');
rm -rf /opt/rt5/var/mason_data/obj
To view a Calendar, first perform a ticket search in the ticket Query Builder and load the search results. Then click the Calendar item in the page menu to see the calendar view based on the results from that search.
By default, RTx::Calendar will display the Starts and Due date fields of each ticket from your search results as events on the Calendar.
Other date fields added to the Format of a ticket search are displayed on the Calendar as events. You can also display events based on Date or DateTime custom fields by adding them to the Format of a ticket search as well.
Hover over events in the calendar to see additional details for that event. You can click on entries to go to the ticket.
You can show other date fields as events on the Calendar by adding them to the Format section at the Advanced tab of your query. You can add and remove dates from search results using the Display Columns section at the bottom of the Query Builder.
Changes made using the Display Columns settings automatically update the search Format. You can also edit the Format directly on the Advanced page.
As described above, you can see a calendar for any ticket search using the calendar link in the search results.
You can also create a saved search for the calendar to be used in calendar portlets on dashboards. See "CONFIGURATION" for details on adding the calendar portlets.
By default, the calendar looks for a saved search with the name "calendar" and will use that search for calendar portlets. Saved searches can be saved with different privacy settings, so your system can have multiple saved "calendar" searches. For a given user, the calendar first checks for a user-level saved search (personal to that user), then for a group-level saved search for groups the user is in, and finally, for a system-level saved search.
Reminders are displayed on the Calendar only if you explicitly add the following clause to your query:
AND ( Type = 'ticket' OR Type = 'reminder' )
The Calendar comes with 3 different portlets that can be added to your RT dashboards:
MyCalendar
A summary of the events for the current week.
Calendar
A full-month view of the Calendar.
CalendarWithSidebar
A full-month view of the Calendar, with a sidebar that includes an extra status filter and legends of the Calendar events.
To make these portlets available in RT, add them to the $HomepageComponents configuration in your etc/RT_SiteConfig.pm:
$HomepageComponents
Set($HomepageComponents, [qw(QuickCreate Quicksearch MyAdminQueues MySupportQueues MyReminders RefreshHomepage MyCalendar Calendar CalendarWithSidebar)]);
Users can then select them when building dashboards.
You can show the owner of the ticket in each event box by adding this line to your etc/RT_SiteConfig.pm:
Set($CalendarDisplayOwner, 1);
When you mouse over events on the calendar, a popup window shows additional details from the ticket associated with that event. You can configure which fields are displayed with @CalendarPopupFields. This is the default configuration:
@CalendarPopupFields
Set(@CalendarPopupFields, ( "OwnerObj->Name", "CreatedObj->ISO", "StartsObj->ISO", "StartedObj->ISO", "LastUpdatedObj->ISO", "DueObj->ISO", "ResolvedObj->ISO", "Status", "Priority", "Requestors->MemberEmailAddressesAsString", ));
To show custom field values, add them using the custom field name in this format: "CustomField.{Maintenance Start}".
"CustomField.{Maintenance Start}"
Valid values are all fields on an RT ticket. See the RT documentation for RT::Ticket for a list.
RT::Ticket
As shown above, for ticket fields that can have multiple output formats, like dates and users, you can also use the Obj associated with the field to call a specific method to display the format you want. The ticket dates shown above will display dates in ISO format. The documentation for RT::Date has other format options. User fields, like Owner, can use the methods shown in the RT::User documentation to show values like EmailAddress or RealName, for example.
Obj
ISO
RT::Date
RT::User
The Calendar shows events in different colors based on the ticket status. Use $CalendarStatusColorMap to set alternate colors or add custom statuses. The following is the default configuration:
$CalendarStatusColorMap
Set(%CalendarStatusColorMap, ( '_default_' => '#5555f8', 'new' => '#87873c', 'open' => '#5555f8', 'rejected' => '#FF0000', 'resolved' => '#72b872', 'stalled' => '#FF0000', ));
You can use any color declaration that CSS supports, including hex codes, color names, and RGB values.
The _default_ key is used for events that don't have a status in the $CalendarStatusColorMap hash. The default color is a dark tone of blue.
_default_
The Calendar has a Filter on Status section that allows you to filter events by status without having to change the original query. The @CalendarFilterStatuses setting controls which statuses are available for filtering. The following is the default:
@CalendarFilterStatuses
Set(@CalendarFilterStatuses, qw(new open stalled rejected resolved));
You can change the default selected statuses of the Filter On Status section by defining @CalendarFilterDefaultStatuses. The following is the default:
@CalendarFilterDefaultStatuses
Set(@CalendarFilterDefaultStatuses, qw(new open));
The calendar shows different icons for events based on the date fields used to display the event on that day. The %CalendarIcons setting controls which icons are used for each date field. The following is the default using provided icons:
%CalendarIcons
Set(%CalendarIcons, ( 'Reminder' => 'reminder.png', 'Resolved' => 'resolved.png', 'Starts, Due' => 'starts_due.png', 'Created, Due' => 'created_due.png', 'Created' => 'created.png', 'Due' => 'due.png', 'Starts' => 'starts.png', 'Started' => 'started.png', 'LastUpdated' => 'updated.png', ));
You can also define icons for custom fields by using the following format:
'CF.{Maintenance Start}' => 'maintstart.png', 'CF.{Maintenance Stop}' => 'maintstop.png',
To add custom images, create a directory local/static/images in your installed RT directory (usually /opt/rt5) and copy images files there.
You can use any image format that your browser supports, but PNGs and GIFs with transparent backgrounds are recommended because they will display better to the background color of the events. The recommended size is 10 pixels wide and 7 pixels in high.
By default, calendars display individual events on each day based on the dates in the query.
To display events that span multiple days, such as the full expected duration of a change blackout period, define the fields using the %CalendarMultipleDaysEvents configuration. This option accepts named keys that each define the field to reference for the start (Starts) and end (Ends) of multi-day events. For example:
%CalendarMultipleDaysEvents
Set( %CalendarMultipleDaysEvents, ( 'Project Task' => { 'Starts' => 'Starts', 'Ends' => 'Due', }, ));
The keys, like Project Task, are arbitrary labels to group each set, so you can use a name that helps you identify the entry.
Project Task
You can also define multiple day events for custom fields by using the following format:
Set( %CalendarMultipleDaysEvents, ( 'Maintenance' => { "Starts" => "CF.{Maintenance Start}", "Ends" => "CF.{Maintenance Stop}", }, 'Project Task' => { 'Starts' => 'Starts', 'Ends' => 'Due', }, ));
As with all calendar entries, the date fields referenced in the configuration must be included in the search result Format to display the event on the Calendar.
Best Practical Solutions, LLC
Originally written by Nicolas Chuche <nchuche@barna.be>
All bugs should be reported via email to
L<bug-RTx-Calendar@rt.cpan.org|mailto:bug-RTx-Calendar@rt.cpan.org>
or via the web at
L<rt.cpan.org|http://rt.cpan.org/Public/Dist/Display.html?Name=RTx-Calendar>.
This software is Copyright (c) 2010-2023 by Best Practical Solutions
Copyright 2007-2009 by Nicolas Chuche
This is free software, licensed under:
The GNU General Public License, Version 2, June 1991
To install RTx::Calendar, copy and paste the appropriate command in to your terminal.
cpanm
cpanm RTx::Calendar
CPAN shell
perl -MCPAN -e shell install RTx::Calendar
For more information on module installation, please visit the detailed CPAN module installation guide.