How To: Add a SQL or OData Calendar Widget

Overview

Here is the step-by-step guide on how to add a SQL or OData Calendar Widget to a page.

On the drawer taskbar, click on Content button

When the list of available widgets appear, select SQL or OData Widget

To configure the newly added table, click on the Edit Widget Settings Icon on the upper right corner of the widget.

On the settings page, you can do the following:

Give the calendar its own Title and Description, as well as any translations that are required
Select a Data Source as the source of your content (SQL Calendar Only)
Create or Select an SQL Query which can be used to gather the data (SQL Calendar Only)

Note: To use the Work Item URL, the WorkItemId field must be present in the SELECT statement of the specified query.

Give the calendar its own Title and Description, as well as any translations that are required

Select the OData End Point
Choose the collection to use as the source of data
Provide the Query String to generate the data from the source
Select the Title of the Calendar to be displayed
Give the Calendar a Start and End Date to display
Utilize the URL input as either a specific URL from the OData or a custom URL
By Using UseCustomURL, you can specify a token to be mapped to a property from the Odata collection in the URL by wrapping the token in double curly braces and picking the property to map to from the resulting dropdown.

Note: You must use the absolute URL to the custom URL even if it is local to the portal
Click on Apply to refresh the table.

With v10.5, you can now adjust the colors in a calendar. Provide the Event Color field, and then modify each representative color

On the drawer taskbar, click on Save to save the changes on the page.