UFN_CMSLISTREFRESH_LOOKAHEAD

Returns whether the list refresh business process needs to run.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@BUSINESSPROCESSPARAMETERSETID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_CMSLISTREFRESH_LOOKAHEAD
(
    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null
)
returns bit
as begin
    declare @NEXTID as int = 0;

    exec @NEXTID = dbo.fnGetNextListForRefresh;    
    if @NEXTID > 0
        return 1;

    exec @NEXTID = dbo.fnGetNextAppealForDupSearch;    
    if @NEXTID > 0
        return 1;

    return 0;
end