2.2.4.63 Web Parts Metadata (Nonpersonalized) Result Set

The Web Parts Metadata (Nonpersonalized) Result Set contains the core metadata about the Web Parts that appear on a document. The Web Parts Metadata (Nonpersonalized) Result Set is defined using T-SQL syntax, as follows.

 tp_ID                    uniqueidentifier,
 tp_ZoneID                nvarchar(64),
 tp_WebPartTypeId         uniqueidentifier,
 tp_IsIncluded            bit,
 tp_FrameState            tinyint,
 tp_AllUsersProperties    image,
 tp_PerUserProperties     image,
 tp_PartOrder             int,
 {tp_Flags}               int,
 {AllUsers}               int,
 tp_Cache                 image,
 {Pre_tp_Cache}           int,
 {tp_ListId}              nvarchar(38),
 tp_Type                  tinyint,
 tp_Source                ntext,
 tp_View                  ntext;

tp_ID: The Web Part Identifier (section 2.2.1.27) of the Web Part. This value MUST NOT be NULL.

tp_ZoneID: The name of a Web Part zone. This value can be NULL.

tp_WebPartTypeId: A 16-byte value uniquely identifying the type of the Web Part. This value MUST NOT be NULL.

tp_IsIncluded: If 1, this indicates that the Web Part is visible. This value MUST NOT be NULL.

tp_FrameState: A value that indicates the frame state of the Web Part. The following values are valid.

Value

Description

0

Normal. The Web Part is displayed in its normal state, with title, content, and placement within the page.

1

Minimized. The Web Part is collapsed so that only the title portion of the frame appears.

tp_AllUsersProperties: Properties specified for all users. This value can be NULL.

tp_PerUserProperties: Properties specified on a per-user basis. This value can be NULL.

tp_PartOrder: An ordinal number that indicates the location of the Web Part in relation to other Web Parts in the same zone. This value can be NULL.

{tp_Flags}: A View Flags (section 2.2.2.9) value that specifies view-related settings for this Web Part. This value MUST NOT be NULL.

{AllUsers}: A flag that indicates whether customization or personalization is in effect on this Web Parts page. This value MUST be equal to 1, indicating customization.

tp_Cache: A private data cache for the Web Part. This value can be NULL.

{Pre_tp_Cache}: A private data cache for the Web Part. This value MUST be NULL.

{tp_ListId}: The List Identifier (section 2.2.1.10) of the list (1) to which this Web Part refers, enclosed in braces. If not referencing a list, this value MUST be NULL.

tp_Type: The Page Type (section 2.2.1.14) of this Web Part. This value can be NULL.

tp_Source: Properties of the Web Part as specified by a Windows SharePoint Services-compatible HTML editor. This value can be NULL.

tp_View: An ntext value containing implementation-specific XML used when processing this Web Part. If this Web Part is not a view, this MUST be NULL.