Configure the specific fields for display in a calendar report - Support and Troubleshooting

Configure the specific fields for display in a calendar report Issue  Description By default, on most calendar reports, the system will display the value of the Number [number] and Short Description [short_description] fields from the source table.

In most cases this is usually the fields that end-users would want or expect to see. However, in a few instances, different or additional fields may be needed for display on this report. This Knowledge Base article will describe how additional fields or differing fields can be specified for a particular source table.

Procedure The first step is to determine the source table for the calendar report for which you want to adjust the field choices to display in the report. This table can be determined by checking the Table field of the Calendar type report. It should be noted that the change to modify the displayed fields is actually configured at the table level, and thus once the change has been performed, all calendar reports based on this table will then use the new fields as configured.

Once the internal table name (such as change_request) is determined, we will then need to ensure we are logged into the instance with an account having admin permissions to that instance.

Once logged in to the instance with this permission level, type sys_dictionary.list in the Filter navigator search field and press the Enter key.

In the list of sys_dictionary records that appears, filter the list to locate the record with the Table field equal to that of the source table (i.e. change_request) for which you want to customize the displayed, highlighted fields in the calendar reports and with a Type of Collection . Once this record is located, click the record to open it for editing.

Once the record opens, click the Advanced View Related Link on this record to display additional fields and information regarding this record.

In the Attributes field verify that there is not already an attribute with the name calendar_elements. If there is such a field already found in the Attributes field, set this attribute to the name of the specific field or fields you want to have displayed on Calendar Reports based on this table. If the attribute does not yet exist, this table will use the default settings for this table, which in most cases is number and short_description. If preferred to use different or additional fields, this attribute should then be added to the Attributes field containing a list of one or more field names from that table to display in those calendar reports. If the Attributes field is currently blank, the new Attribute can simply be added in the field as follows:

calendar_elements= Field_List >

However, if the field already contains one or more attributes, this new attribute should be added to the end of the list as follows:

,calendar_elements= Field_List >

Where,

Field_List > is a semicolon delimited list of the specific field names to include for display in the report. For example, to configure the calendar reports based on the change_request table to display the Number, State and Assignment Group fields, the attribute might be written as follows:

calendar_elements=number,state,assignment_group

After adding the attribute as necessary, click the Update button on the sys_dictionary record to save the change.

After this change has been applied to the appropriate table, any calendar reports rendered based on that source table will then display showing the specified fields on the report.

Note: If the calendar_elements attribute is specified for a particular table, this will override the default settings. Thus, if the Number or Short Description fields are to be included in the report they should be implicitly added in the semicolon delimited list of field names.