[vdelairewa]

I have a problem with my routing rules on multiple routes on an Exclusive Gateway. The Routes is dependent on a drop down being selected and whichever checkgroups are selected also. It is not routing correctly. These are my conditions as follows, @@Unit being the drop down and @=chk_request being the checkgroup value.

Route 1 @@Unit == "2" && (@=chk_request <> "1" OR @=chk_request <> "2" OR @=chk_request <> "3" OR @=chk_request <> "4" OR @=chk_request <> "5" OR @=chk_request <> "6" OR @=chk_request <> "7" OR @=chk_request <> "8" OR @=chk_request <> "9" OR @=chk_request <> "10" OR @=chk_request <> "11" OR @=chk_request <> "12" OR @=chk_request <> "13")

Route 2 @@Unit == "2" && (@=chk_request <> "1" OR @=chk_request <> "2" OR @=chk_request <> "3" OR @=chk_request <> "4" OR @=chk_request <> "5" OR @=chk_request <> "6" OR @=chk_request <> "7" OR @=chk_request <> "8" OR @=chk_request <> "9" OR @=chk_request <> "10" OR @=chk_request <> "11" OR @=chk_request <> "12" OR @=chk_request <> "14")

Route 3 @@Unit == "2" && (@=chk_request <> "1" OR @=chk_request <> "2" OR @=chk_request <> "3" OR @=chk_request <> "4" OR @=chk_request <> "5" OR @=chk_request <> "13" OR @=chk_request <> "7" OR @=chk_request <> "8" OR @=chk_request <> "9" OR @=chk_request <> "10" OR @=chk_request <> "11" OR @=chk_request <> "12" OR @=chk_request <> "14")

Route 4 @@Unit == "3" && (@=chk_request == "1" OR @=chk_request == "2" OR @=chk_request == "3" OR @=chk_request == "4" OR @=chk_request == "5" OR @=chk_request == "7" OR @=chk_request == "8" OR @=chk_request == "9" OR @=chk_request == "10" OR @=chk_request == "11")

Route 5 @@Unit == "2" && (@=chk_request <> "1" OR @=chk_request <> "2" OR @=chk_request <> "3" OR @=chk_request <> "4" OR @=chk_request <> "5" OR @=chk_request <> "6" OR @=chk_request <> "7" OR @=chk_request <> "8" OR @=chk_request <> "9" OR @=chk_request <> "10" OR @=chk_request <> "11" OR @=chk_request <> "13" OR @=chk_request <> "14")

[mishika]

Hello,

May you please share your Process or the Dynaform in which you face this problem?
This will help us debug the problem.

Best Regards
Mishika

[vdelairewa]

Hi Mishika

Process Attached as per request. The Gateway I am having problems with are the first 2 gateways of this process.

[mishika]

Hello,

You are facing the issue in routing because the routing conditions you have used are not correct.

For instance:
if you select "2" for @@Unit and "1" for @=chk_request, you will get TRUE for multiple routes i.e. Route1, Route2, Route3, Route5.
This is because you have used OR in comparing different values of chk_request.

You need to correct the conditions you have used according to the requirement.
Is it that for Route1 you want to check @=chk_request ==14?
If so, you need to use the appropriate operator in your routing rule.

Hope this helps

Best Regards
Mishika

[shereensoliman]

i have boolean variable that is can not be change it's value in trigger , i want to check for update row in database
like
$db = '3011588145f029b2e6c5b35006271957'; // UID for the database connection

if
(
executeQuery("UPDATE [dbo].[Roles] SET
[Name] = '".@@roleName."'
,[CountryID] = " .@@Country."
,[RoleDescription] = '".@@Description."'
,[IsActive] = ".@@Status[0] ."
,[LastUpdateDate] = '".date('Y-m-d H:i:s')."'
,[LastUpdatedby] = '".@@Updatedby."'

WHERE ID = " . @@ID ,$db) == 0)

{
@@databaseupdated = 0;}
else
{
@@databaseupdated = 1;}

@@databaseupdated value not updated to 0 or 1