UFN_QUERYVIEWRELATIONSHIP_GETEXISTINGRELATIONSHIPS

Gets a list of related query view object names for the specified added by query ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ADDEDBYID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_QUERYVIEWRELATIONSHIP_GETEXISTINGRELATIONSHIPS(@ADDEDBYID uniqueidentifier)
returns table
as
    return (
        select (select [QVC].[OBJECTNAME] from dbo.[QUERYVIEWCATALOG] [QVC] where [QVC].[ID] = [QVR].[ROOTQUERYVIEWID]) [ROOTQUERYVIEWOBJECTNAME],
            (select [QVC].[OBJECTNAME] from dbo.[QUERYVIEWCATALOG] [QVC] where [QVC].[ID] = [QVR].[RELATEDQUERYVIEWID]) [RELATEDQUERYVIEWOBJECTNAME],
      [PATHALIAS]
        from dbo.[QUERYVIEWRELATIONSHIP] [QVR] 
    where [QVR].[ADDEDBYQUERYVIEWID] = @ADDEDBYID
    );