ODBC Driver for Exchange

Build 20.0.7587

Folders

Create, update, delete, and query subfolders for a given folder.

テーブル固有の情報

Update およびDelete

本製品 では、アイテムの更新もしくは削除にはFolderChangeKey が必要です。ただし、FolderChangeKey が不明な場合には、本製品 は自動的にExchange サーバーからこれを取得することができます。 これはクエリ実行にかかる時間を増加させることに注意してください。

Columns

Name Type ReadOnly Description
FolderId [KEY] String True

Contains the unique identifier of an folder in the Exchange store.

FolderChangeKey String True

Contains the unique change key of an folder in the Exchange store.

ParentFolderId String False

Represents the unique identifier of the parent folder that contains the item or folder.

ParentFolderChangeKey String True

Represents the unique change key of the parent folder that contains the item or folder.

FolderClass String False

Represents the folder class for a given folder.

DisplayName String False

Contains the display name of a folder.

TotalCount Integer True

Represents the total count of items within a given folder.

ChildFolderCount Integer True

Represents the number of child folders that are contained within a folder.

CanDelete Boolean True

Indicates whether a managed folder can be deleted by a customer.

CanRenameOrMove Boolean True

Indicates whether a given managed folder can be renamed or moved by the customer.

MustDisplayComment Boolean True

Indicates whether the managed folder comment must be displayed.

HasQuota Boolean True

Indicates whether the managed folder has a quota.

IsManagedFoldersRoot Boolean True

Indicates whether the managed folder is the root for all managed folders.

ManagedFolderId String True

Contains the folder Id of the managed folder.

Comment String True

Contains the comment that is associated with a managed folder.

StorageQuota Integer True

Describes the storage quota for the managed folder.

FolderSize Integer True

Describes the total size of all the contents of a managed folder.

HomePage String True

Specifies the URL that will be the default home page for the managed folder.

UnreadCount Integer True

Represents the count of unread items within a given folder.

EffectiveRights_CreateAssociated Boolean True

Indicates whether a client can create an associated contents table.

EffectiveRights_CreateContents Boolean True

Indicates whether a client can create a contents table.

EffectiveRights_CreateHierarchy Boolean True

Indicates whether a client can create a hierarchy table.

EffectiveRights_Delete Boolean True

Indicates whether a client can delete a folder or item.

EffectiveRights_Modify Boolean True

Indicates whether a client can modify a folder or item.

EffectiveRights_Read Boolean True

Indicates whether a client can read a folder or item.

EffectiveRights_ViewPrivateItems Boolean True

Indicates whether a private item can be viewed.

SharingEffectiveRights String False

Indicates the permissions that the user has for the contact data that is being shared.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ImpersonationUser String

The Identifier of the user to impersonate.

ImpersonationType String

The type of Identifier used for the impersonation user (PrincipalName, SID, PrimarySmtpAddress, SmtpAddress).

ParentFolderName String

Represents the distinguished folder Id of the parent folder.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587