AttendeeAvailabilityExchangeEvents
From Agility
<?xml version="1.0" encoding="utf-8"?>
<export>
<configuration>
<separator>;</separator>
<textquote>"</textquote>
<newline>\r\n</newline>
<encoding>UTF8</encoding>
</configuration>
<contents>
<variable name="ViewStartDate">ConvertUnixEpochTime(Convert("decimal",#Request.start) * 1000)</variable>
<variable name="ViewEndDate">ConvertUnixEpochTime(Convert("decimal",#Request.end) * 1000)</variable>
<variable name="aID">#Request.aID</variable>
<variable name="mEvents">JSequence()</variable>
<foreach table="emBookingAttendeesView" datacontext="dataset" classname="External:DataBO.ProcessMngt.BookingAttendeeBO">
<dbfilter>
emBookingAttendeesView.id = #aID
</dbfilter>
<variable name="mAttendeeID">emBookingAttendeesView.AttendeeID</variable>
<variable name="exchangeEmail">if(emBookingAttendeesView.HasExchangeAccount, emBookingAttendeesView.EMailAddr, null)</variable>
<foreach table="ExchangeEvents" datacontext="expression">
<expression>
this().getExchangeEvents(#exchangeEmail, #ViewStartDate, #ViewEndDate)
</expression>
<variable name="allDay">if(datediff("DAY", StartDate, EndDate) >= 1, true, false)</variable>
<data>
(#mEvents).Add(
JObject(
"id", 111,
"allDay", #allDay,
"title", Description,
"start", StartDate,
"end", if(#allDay, (EndDate).AddMinutes(-1), EndDate),
"color", "#FF8000",
"tooltip", translate("Exchange Event")
)
)
</data>
</foreach>
</foreach>
<!--
"2009-11-05T13:15:30Z"
<data>
JSequence(
JObject(
"id", 111,
"title", "Event1",
"start","2013-12-10"
),
JObject(
"id", 222,
"title", "Event2",
"start", "2013-12-20",
"end", "2013-12-22"
)
)
</data>
<data>
"vsd: " + #ViewStartDate + "\r\n" +
"ved: " + #ViewEndDate + "\r\n"
</data>
-->
<const>
#mEvents
</const>
</contents>
</export>