3.1.5.19.18 Web Parts Metadata, Nonpersonalized Result Set

The Web Parts Metadata, Nonpersonalized Result Set contains the core metadata about the Web parts appearing on the specified document.

The Web Parts Metadata, Nonpersonalized Result Set is part of a series of result sets describing view Web page-related metadata. It MUST return only if the input @PageView is 0.

The Web Parts Metadata, Nonpersonalized Result Set will not return if proc_FetchDocForHttpGet returns a code of 1271, indicating that the site collection was locked.

The Web Parts Metadata, Nonpersonalized Result Set MUST contain one row per Web part.

       tp_Id                          uniqueidentifier,
       tp_ZoneID                      nvarchar(64),
       tp_WebPartTypeId               uniqueidentifier,
       tp_Assembly                    nvarchar(255),
       tp_Class                       nvarchar(255),
       tp_SolutionId                  uniqueidentifier,
       Hash                           nvarchar(50),
       ValidatorsHash                  nvarchar(64),
       ValidationErrorUrl,             nvarchar(4000),
       ValidationErrorMessage,         nvarchar(4000),
       tp_IsIncluded                  bit,
       tp_FrameState                  tinyint,
       tp_AllUsersProperties          varbinary(max),
       tp_PerUsersProperties          varbinary(max),
       tp_PartOrder                   int,
       {tp_Flags}                     int,
       {AllUsers}                     int,
       tp_Version                     int,
       tp_Cache                       varbinary(max),
       {Per_tp_Cache}                 varbinary(max),
       {tp_ListId}                    nvarchar(38),
       tp_Type                        tinyint,
       tp_Source                      nvarchar(max),
       tp_BaseViewId                  int,
       tp_View                        nvarchar(max);

tp_Id: The web part identifier (section 2.2.1.15) 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. MUST NOT be NULL.

tp_Assembly: The assembly name of the implementation of the Web Part.

tp_Class: The fully qualified class name of the implementation of the Web Part.

SolutionId: The solution identifier of the solution. MUST be NULL if there is no solution associated with the Web part.

Hash: The implementation-specific hash of the contents of the sandboxed solution. This value MUST NOT be NULL.

ValidatorsHash: The implementation-specific hash of the sandboxed solution validators that validated the sandboxed solution. This value MUST NOT be NULL.

ValidationErrorUrl: The URL to render if the sandboxed solution validator failed validation. This value MUST be NULL if there is no solution associated with the Web part.

ValidationErrorMessage: The error message string to render if the sandboxed solution validator failed validation. This value MUST be NULL if there is no solution associated with the Web part.

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

tp_FrameState: A value that indicates the frame state of the Web part. This value MUST be one of the following.

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.

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

tp_PerUsersProperties: Properties specified for per-user basis. This value can be NULL.

tp_PartOrder: 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.12) 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_Version: A counter incremented any time a change is made to the schema or other properties of this list and used for internal conflict detection.

tp_Cache: Private data cache for the Web part. This value can be NULL.

{Per_tp_Cache}: Private data cache for published documents. This value MUST be NULL.

{tp_ListId}: The list identifier (section 2.2.1.5) of the list 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.3.14) of this Web part. This value can be NULL.

tp_Source: Properties of the Web part as specified by a compatible HTML editing application. This value can be NULL.

tp_BaseViewId: The ID of the base view for the list view Web part, the value can be NULL.

tp_View: An nvarchar(max) value containing implementation-specific XML used when processing this Web part. If this Web part is not a view, this MUST be NULL.