UFN_PLANNEDGIFTLETTERCODE_GETPLANNEDGIFTLETTERCODEFROMOUTPUTDATALIST

Returns planned gift letter codes and their corresponding output data list IDs.
Return

Return Type
table
Definition

Copy


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