Hi, Does anyone know if there is a plugin or function that can be use

Hi,

Does anyone know if there is a plugin or function that can be used to extract the dates defined in the Appian specific calendar? We want to keep the holiday dates between Appian and our SQL Server in sync.

...

OriginalPostID-86115

OriginalPostID-86115

  Discussion posts and replies are publicly visible

Parents
  • There's no plug-in to analyze a calendar but:

    1. There are date and time functions that take a calendar name such as calisworkday() which will determine if the passed datetime is a working day or not
    2. You can also use the API to analyze your calendars:


    WorkingCalendar[] calendars = (WorkingCalendar[]) calendarService.getCalendarsPaging(0,
    Constants.COUNT_ALL, TaskSummary.SORT_BY_NAME, Constants.SORT_ORDER_ASCENDING).getResults();

    for (WorkingCalendar workingCalendarItem : calendars) {

    //Use any method over workingCalendarItem that may fit your requirements from the ones available at forum.appian.com/.../WorkingCalendar.html

    }
Reply
  • There's no plug-in to analyze a calendar but:

    1. There are date and time functions that take a calendar name such as calisworkday() which will determine if the passed datetime is a working day or not
    2. You can also use the API to analyze your calendars:


    WorkingCalendar[] calendars = (WorkingCalendar[]) calendarService.getCalendarsPaging(0,
    Constants.COUNT_ALL, TaskSummary.SORT_BY_NAME, Constants.SORT_ORDER_ASCENDING).getResults();

    for (WorkingCalendar workingCalendarItem : calendars) {

    //Use any method over workingCalendarItem that may fit your requirements from the ones available at forum.appian.com/.../WorkingCalendar.html

    }
Children
No Data