UFN_LETTERCODE_GETLETTERCODEFROMOUTPUTDATALIST

Returns letters and their corresponding output data list IDs.
Return

Return Type
table
Definition

Copy


            CREATE function dbo.UFN_LETTERCODE_GETLETTERCODEFROMOUTPUTDATALIST()
            returns table
            as
            return
                select
                    LETTERCODE.ID as LETTERCODEID,
                    QUERYVIEWSPEC.value
                    (
                        'declare namespace bbafx="bb_appfx_queryview";
                        declare namespace c="bb_appfx_commontypes";
                        (bbafx:QueryViewSpec/c:MetaTags/@DataListID)[1]','char(36)'
                    ) as DATALISTID,
                    LETTERCODE.CUSTOMPARAMETERDATAFORMITEM              
                from 
                    dbo.QUERYVIEWCATALOG
                inner join 
                    dbo.LETTERCODE on QUERYVIEWCATALOG.ID = LETTERCODE.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