cancel
Showing results for 
Search instead for 
Did you mean: 

request for approval

tgyc001
Explorer
0 Kudos

hello everyone, i am facing a problem regarding my query. hope i can find a solution please. when I enter this query:

declare DocTotalSy double: = 0;

declare sRet nvarchar (10): = 'False';

if DocTotalSy> = 304898 then

sRet: = 'True'; end if;

if DocTotalSy <304898 then

sRet: = 'True';

end if;

select: sRet from DUMMY;

under the conditions of approval models with amount intervals it works but instead of triggering the concerned approval model it also triggers some approval models. which implies that there is an overlap in the amounts. so I would like to have a more refined query

Accepted Solutions (0)

Answers (0)