UFN_MANAGEPURPOSEDESIGNATIONINFORMATION_GETCHOSENITEMS_FROMITEMLISTXML

Returns the Manage Purpose and Designation Global Change chosen items.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DataFormItem	xml	IN

Definition

Copy



            create function dbo.UFN_MANAGEPURPOSEDESIGNATIONINFORMATION_GETCHOSENITEMS_FROMITEMLISTXML(@DataFormItem xml)
            returns table as 
            return(
                select
                    T.c.value('(ID)[1]', 'int') as ID
                    ,T.c.value('(NAME)[1]', 'nvarchar(255)') as NAME
                    ,T.c.value('(SELECTEDACTION)[1]', 'int') as SELECTEDACTION
                    ,T.c.value('(NEWVALUE)[1]', 'uniqueidentifier') as NEWVALUE
                from @DataFormItem.nodes('//CHOSENITEMS/ITEM') T(c)
            )