My Calendar

Configuring My Calendar

Alloy Navigator is shipped with the default My Calendar settings, which allows you to view various dates, or "calendar events", on your calendar. You can view these default calendar settings, modify them, and add new events for your calendar. My Calendar supports two types of calendar events:

• Single dates - various dates for Alloy Navigator objects, such as the Due Date for Work Orders or the Expiration Date for Software Licenses.

• Continuous events - periods between two dates for Alloy Navigator objects; for example, Incidents from their Start Date to Due Date, or Contracts between their Start Date and End Date. My Calendar shows continuous events as bars that begin at the start date and end at the end date.

You can filter any calendar events as you need; for example, you can configure your calendar to display only your Work Orders that are currently in progress, from their Start Date to Due Date. Another example is displaying the Date Required only for received Purchase Orders.

To configure My Calendar:

1. In My Calendar, click Settings on the Module menu to bring up the My Calendar Event Settings window.

2. All calendar events are grouped under their object class. Specify which events your calendar will show:

• To create a new calendar event:

1. Click New to bring up the Calendar Event window.

2. In the Object Class list, select the class of objects to show.

3. For a single date event, specify the Start Date. For a continuous event, specify the Start Date and the End Date.

4. If you want to filter event in My Calendar, click the ellipsis button in the Object Filter field and define a condition in either of two modes: Design mode and SQL mode.

• Design Mode - allows to use the graphical Filter Builder. The Design mode is set by default. You can change the mode by clicking Switch to SQL Mode.

  • To add a condition:

    1. On the Filter Menu, click Add Condition, or click the plus button to the right of a row.

    2. Define the condition: choose the field to compare, the comparison operator and value to compare with (if applicable to the chosen operator). For details, see Using operators in the Filter Builder. If the comparison operator is either "like" or "not like", in the value you can use the wildcards: "_"  representing any single character or "%" representing any sequence of characters.

    To define the value, you can also use the following placeholders: <Current User>, <Current User Organization>, and <Current User Location>, which will be replaced with the respective values from the Full Name, Organization, and Location fields of the current user’s Person record.

  • To add a group of conditions:

    1. On the Filter Menu, click Add Group, or click button to the right of a row.

    2. In the new group row, choose the operator to combine the conditions within the group (the default operator is all matched, you can also choose any matched, one failed, or all failed). For details, see Using operators in the Filter Builder.

    3. Define the conditions in the group.

  • To remove a condition or a group of conditions:

    • Select the corresponding row and click Delete Row on the Filter Menu, or click the minus button to the right of the row.

  • To move a condition into another group:

    • To move a condition into another group, use Move Up (Move Down) commands on the Filter Menu. Alternatively, you can use the drag icon (three gray parallel lines ) to the left of each row.

• SQL Mode - allows you to directly specify the SQL WHERE clause. This mode is recommended for advanced SQL users only. You can change the mode by clicking Switch to Design Mode. However, all the data entered in the SQL Mode will be lost.

  • Click here to show the examples of SQL WHERE clauses for Incidents

    Meaning	WHERE clause
    Show overdue Incidents	(DATEDIFF(n, [Due_Date], [Completed_Date]) >0) OR ([Completed_Date] is NULL) AND(DATEDIFF(n, [Due_Date], GETDATE()) >0)
    Show overdue Incidents which status is neither Closed nor Resolved	([Status] <> N'Resolved') and ([Status] <> N'Closed') and (DATEDIFF(n, [Due_Date], GETDATE()) >0)
    Show unassigned Incidents	([Status] = N'Unassigned') and (([Assignee] ='') or ([Assignee] is NULL))

  • Click here to show the examples of SQL WHERE clauses for Computers

    Meaning	WHERE clause
    Show leased Computers with expired Lease Return date	[Lease] = '1' AND (DATEDIFF(n, [Lease_Return_Date], GETDATE()) >0)
    Show out-of-warranty Computers	(DATEDIFF(n, [Warranty_Exp], GETDATE()) >0)

5. Type the description for your calendar event in the Description field. This description will help you identify the event in the Calendar Events pane, where you can temporary hide this event and display it again right from your calendar. For details, see Hiding calendar events. If you keep the Description field empty, Alloy Navigator will display the event as follows:

   • For a one-date event: [Start Date]

   • For a continuous event: [Start Date to [End Date]

   NOTE: If your calendar event has a filter, the My Calendar Event Settings window would display the filtering expression in brackets; for example: Due Date (([Status] = N'In Progress') and ([Type] = N'Issue') and ([Assignee_Group] = N'Service Desk')). However, My Calendar does not display filtering expressions in the Calendar Events pane due to the lack of space, so we recommend that you specify a short, meaningful description for filtered objects.

6. By default, each newly added calendar event is enabled, i.e. My Calendar will display its dates when the event condition is true. If you don't want My Calendar to display the dates for your event, clear the Enabled check box.

• The event list displays check boxes for all calendar events. Selected check box means that the calendar event is enabled, i.e. My Calendar displays its dates when the event condition is true. If you don't want My Calendar to display the dates for an event, clear its check box in the list.

NOTE: You can also disable or re-enable calendar events directly from the calendar; for details, see Hiding calendar events.

• To modify a calendar event:

  1. Double-click the event to bring up the [Calendar Event] window.

  2. Make your changes and click OK.

• To delete a calendar event:

• Select the event and click Delete.

3. View the list of calendar events and click OK to close the window.