UFN_ADHOCQUERY_GETHIERARCHY_FROMITEMLISTXML
Used to convert an xml string to a table based on UFN_ADHOCQUERY_GETHIERARCHY.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/21/2013 3:34:07 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.506.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_ADHOCQUERY_GETHIERARCHY
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_ADHOCQUERY_GETHIERARCHY_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT
T.c.value('(APPLYASDEFAULTPERMISSIONSFORALLSUBFOLDERS)[1]','bit') AS 'APPLYASDEFAULTPERMISSIONSFORALLSUBFOLDERS',
T.c.value('(DATEADDED)[1]','datetime') AS 'DATEADDED',
T.c.value('(DESCRIPTION)[1]','nvarchar(1024)') AS 'DESCRIPTION',
T.c.value('(DISPLAYORDER)[1]','int') AS 'DISPLAYORDER',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(ISFAVORITE)[1]','bit') AS 'ISFAVORITE',
T.c.value('(ITEMTYPE)[1]','int') AS 'ITEMTYPE',
T.c.value('(NAME)[1]','nvarchar(255)') AS 'NAME',
T.c.value('(PARENTFOLDERID)[1]','uniqueidentifier') AS 'PARENTFOLDERID',
T.c.value('(QUERYDEFAULTALLOWALLUSERSTOEDIT)[1]','bit') AS 'QUERYDEFAULTALLOWALLUSERSTOEDIT',
T.c.value('(QUERYDEFAULTALLOWALLUSERSTORUN)[1]','bit') AS 'QUERYDEFAULTALLOWALLUSERSTORUN',
T.c.value('(SECURITYLEVEL)[1]','nvarchar(14)') AS 'SECURITYLEVEL',
T.c.value('(SMARTQUERYDEFAULTALLOWALLUSERSTOEDIT)[1]','bit') AS 'SMARTQUERYDEFAULTALLOWALLUSERSTOEDIT',
T.c.value('(SMARTQUERYDEFAULTALLOWALLUSERSTORUN)[1]','bit') AS 'SMARTQUERYDEFAULTALLOWALLUSERSTORUN',
T.c.value('(TYPE)[1]','nvarchar(50)') AS 'TYPE'
FROM @ITEMLISTXML.nodes('/ADHOCQUERYHIERARCHY/ITEM') T(c)
)