Fundamentación de la metodología utilizada

The proc_GetFullLinkInfoForSingleDoc stored procedure is called to return information of all the links for a single document. The T-SQL syntax for the stored procedure is as follows:

PROCEDURE proc_GetFullLinkInfoForSingleDoc(

@DocSiteId uniqueidentifier, @DocDirName nvarchar(256), @DocLeafName nvarchar(128), @UserId int,

@AttachmentsFlag tinyint, @MaxCheckinLevel tinyint, @GetWebListForNormalization bit,

@RequestGuid uniqueidentifier = NULL OUTPUT );

@DocSiteId: The site collection identifier of the site collection containing the document. MUST NOT be NULL.

@DocDirName: The directory name of the directory containing the document. MUST NOT be NULL.

@DocLeafName: The leaf name of the document. MUST NOT be NULL.

@UserId: The user identifier of the current user. MUST NOT be NULL.

@AttachmentsFlag: Bit that governs the type of security checks which SHOULD be performed by a stored procedure on this document's URL, based on whether it appears to be an attachment. A value which MUST be listed in the following table.

Value Description

0 The URL does not appear to be an attachment.

1 The URL is an attachment file. The directory name of the document has the string "Attachments"

as its next-to-last path segment, and a 32-bit base-10 signed integer as the last path segment that is referring to the item identifier to which this file is attached and where the permissions will be checked. For example, Announcements/Attachments/17/file1.txt.

2 The URL is a folder containing list item attachments. For example, Announcements/Attachments/17.

3 The URL is the folder containing the list attachments. The last path segment of the URL is the string "Attachments". For example, "Announcements/Attachments".

@MaxCheckinLevel: A Publishing Level Type, (as specified in [MS-WSSFO2] section 2.2.2.6) value specifying the maximum publishing level of the links to return.

@GetWebListForNormalization: Bit flag indicating that the Web List For Normalization Result Set (section 3.1.4.57.1) SHOULD be returned.

@RequestGuid: The optional request identifier for the current request.

Return values: An integer that MUST be listed in the following table.

Value Description 0 Success

2 The Document store type of the specified object is not zero and it is not an item in a list (1) or document library.

Result sets: The stored procedure might return the Web List For Normalization Result Set, and MUST return the Individual URL Security Result Set (section 3.1.4.57.3), the Document Link Information Result Set (section 3.1.4.57.4), and the Document Setup Path Result Set (section 3.1.4.57.5).

3.1.4.57.1 Web List For Normalization Result Set

If the @GetWebListForNormalization flag is set to true, the Web List For Normalization Result Set returns a list of Fully qualified URL for subsites of the specified site (2). The result set will contain zero or more rows. The T-SQL syntax for the result set is as follows:

FullUrl nvarchar(256);

FullUrl: Full URL of a subsite.

3.1.4.57.2 NULL Individual URL Security Result Set

The NULL Individual URL Security Result Set MUST only be returned if the specified document location is NOT contained within a list (1) or document library. It MUST contain a single row. The NULL Individual URL Security Result Set is defined in [MS-WSSFO2] section 2.2.5.14.

3.1.4.57.3 Individual URL Security Result Set

The Individual URL Security Result Set contains security information about the specified document. If the document does not exist, but the specified URL is within a list (1) or document library, security information is returned from the effective security scope for the specified document location.

The Individual URL Security Result Set MUST ONLY be returned if the specified document location is contained within a list (1) or document library. Otherwise, the NULL Individual URL Security Result Set (section 3.1.4.57.2) MUST be returned. If returned, the Individual URL Security Result Set MUST contain a single row. The Individual URL Security Result Set is defined in [MS-WSSFO2] section 2.2.5.10.

3.1.4.57.4 Document Link Information Result Set

The Document Link Information Result Set returns information about each forward link from the document and backward link to the document within the site collection. The result set MUST be returned and MUST contain one row for each forward link within the specified document, and one row for each backward link to the document within the specified site collection. The T-SQL syntax for the result set is as follows:

LinkDirName nvarchar(256), LinkLeafName nvarchar(128), LinkType tinyint, LinkSecurity tinyint, LinkDynamic tinyint, LinkServerRel bit, LinkStatus tinyint, PointsToDir bit, WebPartId int, LinkNumber int,

WebId uniqueidentifier, Search ntext,

FieldId uniqueidentifier;

LinkDirName: The directory name of the directory containing the linked object. This value MUST NOT be NULL.

LinkLeafName: The leaf name of the linked object. This value MUST NOT be NULL.

LinkType: Type of the link. Refer to [MS-WSSFO2], section 2.2.3.10, for valid values.

LinkSecurity: A 1-byte (tinyint) value represented as a single upper case ASCII character specifying the link's security type. Refer to [MS-WSSFO2], section 2.2.3.9 for valid values.

LinkDynamic: A 1-byte (tinyint) value represented as a single upper case ASCII character that tracks various special link types. The value MUST be one of the values in the following table.

Value Description

"68"

(D) The URL is "dynamic", which is a link to <Site URL>/_vti_bin/shtml.dll/DirName/LeafName.

Such links are used to call the SmartHTML interpreter on a file.

"71"

(G) A non-absolute link from an uncustomized document that does not fall into any other category.

Value Description

"72"

(H) The URL is a history link; that is, it contains a path segment with the string "_vti_history".

"76"

(L) The URL is to a layouts page; that is, it contains a path segment with the string "_layouts".

"83"

(S) The URL is "static", which is the default, and requires no special handling.

LinkServerRel: A bit flag that specifies whether the link URL is server-relative URL. A value of "1"

specifies a server-relative URL. This value MUST be NULL for a backward link.

LinkStatus: The document store type value of the document targeted by a link. This value MUST be

"128" for a backward link. If the forward link target is a document that does not exist, or if the forward link refers to a target that exists outside the specified site collection, or if it refers to a location that could not be verified, this value MUST be NULL.

PointsToDir: A bit flag specifying whether the target of the forward link was a directory and has been modified to target a Welcome page. This value MUST be NULL for a backward link. For a forward link, if the target is a directory where a Welcome page is specified, the link MUST be changed to the URL of the Welcome page and this value MUST be "1" so that the link can be distinguished from an explicit link to the Welcome page; otherwise this value MUST be zero ("0").

WebPartId: MUST be NULL.

LinkNumber: MUST be NULL.

WebId: Site identifier for backward links.

Search: Search parameters for backward links.

FieldId: If the link is for a list item field (1) within this document, this is the field identifier of the field (1) to which this the link belongs.

3.1.4.57.5 Document Setup Path Result Set

The T-SQL syntax for the Document Setup Result Set is as follows:

{DocSetupPath} nvarchar(255);

{DocSetupPath}: For a document that is now or once was uncustomized, this contains the setup path fragment relative to the base setup path where the content stream of this document can be found. This value MUST be NULL if the document was never uncustomized.