Hi,
I have human task(task1) to insert first name of employee to input field in form,then assign it to process variable named (newvar) of type text.in the second human task(task2) I can print the entered value of (newvar) in the form.in the third human task (task3) I made a connetor to mysql database to get number of leaves to employee according to entered name(newvar) and I used the following query:
SELECT num_of_admin_leave FROM db_full_company.employee where first_name='$"{newvar}"' ;
