Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderators: ArturoRobles, ArturoRobles

By vdelairewa
#791724
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")
By mishika
#792907
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
#828228
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] = '"[email protected]@roleName."'
,[CountryID] = " [email protected]@Country."
,[RoleDescription] = '"[email protected]@Description."'
,[IsActive] = "[email protected]@Status[0] ."
,[LastUpdateDate] = '".date('Y-m-d H:i:s')."'
,[LastUpdatedby] = '"[email protected]@Updatedby."'

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

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

@@databaseupdated value not updated to 0 or 1

Hello, Is it possible to set variables in a defau[…]

yes but still no luck. :( 2.PNG we deleted all t[…]

When a process is double click or highlighted to s[…]

Error clicking on Participated

after follow the troubleshooting http://pmlearning[…]