We are using JBoss but MSSQL, not MySQL.
I also decided to change the process slightly to avoid unnecessary steps and, perhaps, this query step altogether.
So this is what I have so far: A Set Value task to fill the form, and an Assign User to assign the form for review. Upon acceptance by the Reviewer, the form should be saved and/or printed, as selected by the Reviewer. Upon reject, it should be reassigned to the Process Creator for correction/completion. When this is done, the form should be resubmitted for review.
The form is filled, but the Reviewer gets nothing in his queue (To Do list), even thought he's assigned in the process. The email notifications are not working correctly yet, but it should still be assigned to the Reviewer, correct? He's the Specific User in the Initial User Selection property.
I'd appreciate any help that you can provide.
Thanks!