Column definitions for WDS 2.6.5?

Hi,

Can anyone provide the definitions for the columns that are available in WDS 2.6.5 The SDK still indicates that the column definitions are changing and the only definitions I can find are those in the sample program. The definitions that are in there are insufficient for what I need to do.

At a minimum, I need to access the email address information for email messages (to, from, cc, bcc)


Answer this question

Column definitions for WDS 2.6.5?

  • Val Savvateev

    Column name description type propid index retrieve sparse fast_sort max_size
    DocComments Comments VT_LPWSTR F29F85E0-4FF9-1068-AB91-08002B27B3D9/6 yes yes
    Create The date and time the file was created. - type is VT_FILETIME. The Indexing Service friendly name is 'create'. VT_FILETIME B725F130-47EF-101A-A5F1-02608C9EEBAC/15 yes yes no
    DisplayFolder User-friendly folder for item VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/DisplayFolder yes yes no yes 1023
    DocAuthor Author VT_LPWSTR F29F85E0-4FF9-1068-AB91-08002B27B3D9/4 yes yes no yes
    DocCategory Category VT_LPWSTR D5CDD502-2E9C-101B-9397-08002B2CF9AE/2 yes yes
    DocKeywords Not mapped to VT_LPWSTR F29F85E0-4FF9-1068-AB91-08002B27B3D9/5 yes yes
    DocTitlePrefix prefix of subject (Re: Fw: etc.) VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/DocTitlePrefix yes yes no
    DocTitle Title VT_LPWSTR F29F85E0-4FF9-1068-AB91-08002B27B3D9/2 yes yes no yes
    FileExtDesc User-friendly Description of the file type from the registry (Ex: .psq --> Product Studio Query File) VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/FileExtDesc yes yes yes
    FolderName The name of the parent folder VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/FolderName yes yes no
    IsAttachment flag for an item being an attachment VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsAttachment yes yes no
    IsDeleted This item is marked for deletion (Recycle bin, deleted items, etc.) VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsDeleted yes yes no
    LastViewed Date the item was last viewed by the user (SIS requested) VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/LastViewed yes yes
    People People involved with this item VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/People yes yes
    PerceivedType The perceived type of the object NOTE: This is only for retrieval is VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/PerceivedType yes yes no yes
    PerceivedTypeKeyword Perceived Type Keywords which can surface this item NOTE: This is locale specific and can contains synonym terms. DO WE NEED THIS JonasBar -says: I don't think so. We handle this differently now. - this could really be the is relationship to the item [davidd] VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/PerceivedTypeKeyword yes no
    PerceivedTypeName The display name of the perceivedType. Never displayed or queried VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/PerceivedTypeName yes yes no
    PrimaryDate Most interesting Date (Last Write time for files DateReceived for ) VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/PrimaryDate yes yes no yes
    Size The size of a file. - type is VT_I8. The Indexing Service friendly name is 'size'. VT_I8 B725F130-47EF-101A-A5F1-02608C9EEBAC/12 yes yes no yes
    DocSubject Today only file subjects get mapped to this although email subjects would in theory map -- email subjects map to PrimaryTitle today and don't get duplicated due to their length VT_LPWSTR F29F85E0-4FF9-1068-AB91-08002B27B3D9/3 yes yes no yes
    Url query based url VT_LPWSTR 49691C90-7E17-101A-A91C-08002B2ECDA9/9 yes yes no 1023
    Write The date and time of the last write to the file. - type is VT_FILETIME. The Indexing Service friendly name is 'write'. VT_FILETIME B725F130-47EF-101A-A5F1-02608C9EEBAC/14 yes yes no yes
    DueDate Date something is due VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/DueDate yes yes
    IsIncomplete This item is not fully available VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsIncomplete yes yes no
    IsFlaggedCompleted TRUE if has completed flag VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsFlaggedCompleted yes yes
    IsFlagged TRUE if has any flag VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsFlagged yes yes
    FlagText VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/FlagText yes yes
    Identity Identity for OE users VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/Identity yes yes
    IsRead Flag for message read/unread VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsRead yes yes no
    Importance MAPI Importance. Map priority to this also as it is a synonym VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/Importance yes yes
    Characterization First Part in the Contents stored in the property store VT_LPWSTR 560C36C0-503A-11CF-BAA1-00004C752A9A/2 no yes 1023
    ContainerHash hash code used to identify attachments to be deleted based on a common container url VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/ContainerHash yes yes
    Contents The contents of the file. This property is for query restrictions only; it cannot be retrieved in a query result. - type is VT_LPWSTR. The Indexing Service friendly name is 'contents'. VT_LPWSTR B725F130-47EF-101A-A5F1-02608C9EEBAC/19 yes no
    DocFormat The Document Format (aka the MIMETYPE ) (Ex for EML files 'message/rfc822') VT_LPWSTR 0B63E350-9CCC-11D0-BCDB-00805FCCCE04/5 yes yes no
    GatherTimeModified The crawl time when the document was last updated in the catalog. VT_FILETIME 0b63e350-9ccc-11d0-bcdb-00805fccce04/4 yes yes no
    Rank rank of the result (not emitted by anything but queryable) VT_LPWSTR 49691C90-7E17-101A-A91C-08002B2ECDA9/3 yes no no
    Store the store (aka protocol handler) FILE, MAIL, OUTLOOKEXPRESS VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/Store yes yes
    WorkID WorkID VT_UI4 49691C90-7E17-101A-A91C-08002B2ECDA9/5 no yes
    SisInt *internal* prototype tag used by SIS VT_I8 D5CDD505-2E9C-101B-9397-08002B2CF9AE/SisInt yes yes
    SisInt2 *internal* prototype tag used by SIS VT_I8 D5CDD505-2E9C-101B-9397-08002B2CF9AE/SisInt2 yes yes
    SisTag *internal* prototype tag used by SIS VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/SisTag yes yes
    SisTag2 *internal* prototype tag used by SIS VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/SisTag2 yes yes
    SisDate *internal* prototype tag used by SIS VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/SisDate yes yes
    SisDate2 *internal* prototype tag used by SIS VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/SisDate2 yes yes
    Attrib The attribute flags for a file. - type is VT_UI4. The Indexing Service friendly name is 'attrib'. VT_UI4 B725F130-47EF-101A-A5F1-02608C9EEBAC/13 no yes no
    FileExt File Extension VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/FileExt yes yes no
    FileName The name of the file. - type is VT_LPWSTR. The Indexing Service friendly name is 'filename'. VT_LPWSTR B725F130-47EF-101A-A5F1-02608C9EEBAC/10 yes yes no
    ShortName The short (8.3) file name for the file. - type is VT_LPWSTR. The Indexing Service friendly name is 'shortname'. VT_LPWSTR B725F130-47EF-101A-A5F1-02608C9EEBAC/20 yes yes
    AttachmentNames Names of attachments in a message VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/AttachmentNames yes yes
    BccAddress Addresses in Bcc: field VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/BccAddress yes yes
    BccName person names in Bcc: field VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/BccName yes yes
    CcAddress Addresses in Cc: field VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/CcAddress yes yes
    CcName person names in Cc: field VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/CcName yes yes
    ConversationID A unique ID for a conversation in email threads VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/ConversationID yes yes
    FromAddress Addresses in From: field VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/FromAddress yes yes
    FromName Address in from field as person name VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/FromName yes yes yes
    FwdRply Flag whether mail was replied to or fwd'd (cdoPR_ACTION=261 262) VT_I4 D5CDD505-2E9C-101B-9397-08002B2CF9AE/FwdRply yes yes
    HasAttach Whether a mail has an attachment (T or F) VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/HasAttach yes yes no
    ReceivedDate Delivery time VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/ReceivedDate yes yes yes
    ToAddress Addresses in To: field VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/ToAddress yes yes
    ToName person names in To: field VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/ToName yes yes
    TaskStatus status of a task VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/TaskStatus yes yes
    EndDate end time (usually for meetings/events) VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/EndDate yes yes
    IsRecurring Something is recurring (aka meetings) VT_BOOL D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsRecurring yes yes no
    StartDate start time (usually for meetings/events) VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/StartDate yes yes yes
    Duration Length of meeting in minutes VT_I4 D5CDD505-2E9C-101B-9397-08002B2CF9AE/Duration yes yes
    Location Location that something (like a meeting) is occuring VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/Location yes yes
    Anniversary anniversary (wedding ) VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/Anniversary yes yes
    AssistantName Assistant name VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/AssistantName yes yes
    AssistantTelephone Assistant telephone VT_LPWSTR D5CDD505-2E9C-101B-9397-08002B2CF9AE/AssistantTelephone yes yes
    Birthday birthday of contact VT_FILETIME D5CDD505-2E9C-101B-9397-08002B2CF9AE/Birthday yes yes yes
    BusinessAddressCity Business address info