on 11-27-2020 9:39 AM
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
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.