UFN_TRIBUTELETTERCODE_GETLETTERCODEFROMOUTPUTDATALIST

Returns tribute letters and their corresponding output data list IDs.
Return

Return Type
table
Definition

Copy


            CREATE function dbo.UFN_TRIBUTELETTERCODE_GETLETTERCODEFROMOUTPUTDATALIST()
            returns table
            as
            return
                select
                    TRIBUTELETTERCODE.ID as TRIBUTELETTERCODEID,
                    QUERYVIEWSPEC.value
                    (
                        'declare namespace bbafx="bb_appfx_queryview";
                        declare namespace c="bb_appfx_commontypes";
                        (bbafx:QueryViewSpec/c:MetaTags/@DataListID)[1]','char(36)'
                    ) as DATALISTID,
                    TRIBUTELETTERCODE.CUSTOMPARAMETERDATAFORMITEM
                from 
                    dbo.QUERYVIEWCATALOG
                inner join 
                    dbo.TRIBUTELETTERCODE on QUERYVIEWCATALOG.ID = TRIBUTELETTERCODE.QUERYVIEWID
                where
                    not QUERYVIEWSPEC.value
                    (
                        'declare namespace bbafx="bb_appfx_queryview";
                        declare namespace c="bb_appfx_commontypes";
                        (bbafx:QueryViewSpec/c:MetaTags/@DataListID)[1]','char(36)'
                    ) is null