UFN_UIWIDGET_PRODUCTISUIWIDGET

create function dbo.UFN_UIWIDGET_PRODUCTISUIWIDGET(@UIWIDGETID uniqueidentifier)
        returns bit
        with execute as caller
        as begin
          declare @ISPRODUCT bit = 0;

          with xmlnamespaces(default 'bb_appfx_uiwidget', 'bb_appfx_commontypes' as common)
          select @ISPRODUCT = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(
                      UIWIDGETCATALOG.UIWIDGETSPECXML.query('/UIWidgetSpec/common:InstalledProductList')
                  )
          FROM dbo.UIWIDGETCATALOG
          WHERE ID = @UIWIDGETID;

          RETURN @ISPRODUCT;
        end