USP_SEARCHLIST_GETMETADATA_FORTRANSLATION

                CREATE  procedure [dbo].[USP_SEARCHLIST_GETMETADATA_FORTRANSLATION]
                (
                    @ID uniqueidentifier --ID of SEARCHLISTCATALOG
                )
                as
                    set nocount on;

                    select
                        [TFC].[FUNCTIONNAME],
                        [TFC].[PARAMETERDEFINITION],
                        [TFC].[IMPLEMENTATIONTYPE],
                        [TFC].[ASSEMBLYNAME],
                        [TFC].[CLASSNAME],
                        cast(coalesce([TFC].[TRANSLATIONFUNCTIONSPEC].value('declare namespace bbspec="bb_appfx_translationfunction";/bbspec:TranslationFunctionSpec[1]/@RequiresDecryption','bit'), 0) as bit) AS [REQUIRESDECRYPTION],
                        [TFC].[TRANSLATIONFUNCTIONSPEC].query('declare namespace bbspec="bb_appfx_translationfunction";declare namespace common="bb_appfx_commontypes";/bbspec:TranslationFunctionSpec[1]/bbspec:CLRTranslationFunction[1]/common:StaticParameters[1]') as [STATICPARAMETERDEFINITION]
                    from dbo.[SEARCHLISTCATALOG]
                    inner join dbo.[TRANSLATIONFUNCTIONCATALOG] as [TFC] on [SEARCHLISTCATALOG].[TRANSLATIONFUNCTIONCATALOGID] = [TFC].[ID]
                    where [SEARCHLISTCATALOG].[ID] = @ID;

                    return 0;