UFN_PAGEDEFINITION_PRODUCTISPAGE

Evaluates a page definition spec for product flags.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@PAGEID uniqueidentifier IN

Definition

Copy


        CREATE function dbo.UFN_PAGEDEFINITION_PRODUCTISPAGE(@PAGEID uniqueidentifier)
        returns bit
        with execute as caller
        as begin
          declare @ISPRODUCT bit = 0;


          select
              @ISPRODUCT = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(PAGEDEFINITIONCATALOG.INSTALLEDPRODUCTLISTXML)

          from dbo.PAGEDEFINITIONCATALOG
          where ID = @PAGEID;

          return @ISPRODUCT
        end