Restricting appointments in a user's calendar folder using RDO

[nikolaj.sheller]

Hello

My assignment is as follows:
-I need to retrieve user appointments in a given timespan from
Exchange. Due to performance issues I need to be able to restrict the
folders containing appointments server side.

-I currently log on to Exchange using RDOSession, under an account
created specially for this purpose.

My question is:
-How can I restrict the appointments in a given user's calendar folder
using RDO?

My experiences are:
-RDOFolders can't be restricted.
-MAPITables can be restricted, but can't (to my knowledge) be
converted into RDOFolders or RDOAppointmentItems again.
-RDOSearchFolders can contain RDOFolders that are restricted. I can
restrict my own calendar, but not other user's. I can only get a
search folder to access the current user's SharedDefaultFolder, i.e.
the following fails:
"rdoSession.GetSharedDefaultFolder(addressEntry,
rdoDefaultFolders.olFolderCalendar);"
when using "RDOSearchFolder.Start()" on the search folder; although it
works for the special account.

I would appreciate any input regarding this problem.

Thank you
-Nikolaj

 

[Ken Slovak - [MVP - Outlook]]

I use MAPITables for something like that. A restricted MAPITable can have
columns for the EntryID and StoreID of each item so you can retrieve the
individual items if needed, but if you include all the data you need as
columns in the table rows you usually don't even have to do that unless you
need to do something like read a stream that is too big to be retrieved as a
column or if you need to get data from collections like Recipients or
Attachments.

 

[Dmitry Streblechenko]

Contact me at my private e-mail address for a beta version that adds
RDOFolder.GetActivitiesForTimeRange() method - it will return both simgle
instance appointments and expanded instances of recurring appointments.
MAPITable object can be restricted using the MAPITable.Restrict method.
New version of Redemption will also add MAPITable.ExecSQL method that allows
to retrieve the data in a standard ADODB.Recordset object by specifying a
regular SQL expression.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool