2.2.4.32 List Metadata Result Set
The List Metadata Result Set contains the metadata associated with the list (1) containing the requested document. The List Metadata Result Set is defined using T-SQL syntax, as follows.
-
tp_ID uniqueidentifier, tp_Title nvarchar(255), tp_Modified datetime, tp_Created datetime, tp_LastDeleted datetime, tp_Version int, tp_BaseType int, tp_ServerTemplate int, DirName nvarchar(256), LeafName nvarchar(128), DirName nvarchar(256), LeafName nvarchar(128), tp_ReadSecurity int, tp_WriteSecurity int, tp_Description ntext, tp_Fields ntext, tp_Direction int, tp_AnonymousPermMask int, tp_Flags int, tp_ThumbnailSize int, tp_WebImageWidth int, tp_WebImageHeight int, tp_ImageUrl nvarchar(255), tp_ItemCount int, tp_Author int, tp_ACL image, tp_EventSinkAssembly nvarchar(255), tp_EventSinkClass nvarchar(255), tp_EventSinkData nvarchar(255), tp_EmailInsertsFolder nvarchar(255), tp_EmailInsertsLastSyncTime nvarchar(50);
tp_ID: The List Identifier (section 2.2.1.10) of the list (1).
tp_Title: The title of the list (1) for display in the user interface.
tp_Modified: A time stamp in UTC format specifying when the list item within the list (1) was last modified.
tp_Created: A time stamp in UTC format specifying when the list (1) was created.
tp_LastDeleted: A time stamp in UTC format specifying when an item was last deleted from the list (1).
tp_Version: A counter incremented any time a change is made to the list (1), used for internal conflict detection.
tp_BaseType: The List Base Type (section 2.2.1.9) value from which the list (1) is derived.
tp_ServerTemplate: The List Server Template (section 2.2.1.12) enumeration value of the list template that defines the base structure of the list (1).
DirName: The directory name of the location that contains the list (1).
LeafName: The leaf name of the location that contains the list (1).
DirName: The directory name of the default template of the list (1).
LeafName: The leaf name of the default template of the list (1).
tp_ReadSecurity: Special restrictions that can be placed on list item access. The following values are valid.
|
Value |
Description |
|---|---|
|
1 |
No special restrictions. |
|
2 |
Users will see only their own list items. The front-end Web server MUST NOT display list items to users without the ManageLists right unless the list item was created by that user (for example, tp_Author = @UserId). |
tp_WriteSecurity: Special restrictions that can be placed on list item update. The following values are valid.
|
Value |
Description |
|---|---|
|
1 |
No special restrictions. |
|
2 |
Users will see only their own list items. The front-end Web server MUST NOT allow users without the ManageLists right to update a list item unless the list item was created by that user (for example, tp_Author = @UserId). |
|
4 |
Users will not update any list items in the list (1). The front-end Web server MUST NOT allow users without the ManageLists right to add or update list items in the list (1). |
tp_Description: The description of this list (1) for display in the front-end Web server.
tp_Fields: Contains an XML fragment representation of the field definitions. This field can be NULL if the list (1) has not been customized.
tp_Direction: An enumerated value specifying the direction of text flow for front-end Web server elements presented by this list (1). The following values are valid.
|
Value |
Description |
|---|---|
|
0 |
No explicit direction is specified. |
|
1 |
Text flow is left to right. |
|
2 |
Text flow is right to left. |
tp_AnonymousPermMask: A WSS Rights Mask (section 2.2.2.10) that indicates the rights granted to a user that is anonymous, or has no specific rights, on this list (1).
tp_Flags: A List Flags (section 2.2.2.4) value describing this list (1).
tp_ThumbnailSize: The width, in pixels, specified for use when creating thumbnail images of list items within this list (1). This value MUST be NULL for lists that do not have a List Server Template value of 109 (Image Library Template). Thumbnails and web images are front-end Web server generated images of documents that are implementation-specific capabilities.
tp_WebImageWidth: The width, in pixels, that is specified for use when creating web images of list items within this list (1). This value MUST be NULL for lists that do not have a List Server Template value of 109 (Image Library Template).
tp_WebImageHeight: The height, in pixels, that is specified for use when creating web images of list items within this list (1). This value MUST be NULL for lists that do not have a List Server Template value of 109 (Image Library Template).
tp_ImageUrl: The URL of the image that is used to represent this list (1).
tp_ItemCount: The number of list items that are stored within this list (1).
tp_Author: The identifier of the user who created the list (1).
tp_ACL: The permissions for this list (1). If tp_ACL is NULL, then the permissions of the web to which this list belongs apply to this list (1).
tp_EventSinkAssembly: The name of the .NET assembly that contains the class definition that implements the event sink associated with this list (1). This value MUST default to NULL if no event sink has been associated with the list (1).
tp_EventSinkClass: The name of the class definition that implements the event sink associated with this list (1). This value MUST default to NULL if no event sink has been associated with the list (1).
tp_EventSinkData: Additional data persisted on behalf of the event sink implementation, to be passed to the event sink associated with this list (1). This value MUST default to NULL if no event sink has been associated with the list (1).
tp_EmailInsertsFolder: Contains a directory name specifying the directory on the configured email inserts server that SHOULD be inspected for new email messages to be processed for this list (1). If the List Flags for this list do not have the value 0x00010000 set, this field MUST be ignored. This value MUST default to NULL if no email inserts server has been associated with the list (1).
tp_EmailInsertsLastSyncTime: This field is a UTC time stamp encoded as a Unicode string in yyyy-mm-dd hh:mi:ss.mmm format, specifying the last time the location specified in the tp_EmailInsertsFolder column was inspected for new list items. If the List Flags value for this list (1) does not have the value 0x00010000 set, this field MUST be ignored. This value MUST default to NULL if no email inserts server has been associated with the list (1).