AnsweredAssumed Answered

How can i get the values from query?

Question asked by vamsinipun on May 2, 2018

Hi Team,


I am using activiti in my spring web application.


execution.getEngineServices().getRuntimeService().createNativeExecutionQuery().sql("select u.email_id from tbl_employee_reporters er, role r, tbl_emp_professional tep, tbl_emp_professional ep, user_info u where ep.user_id = 1450 and ep.emp_id = er.emp_id and er.type = 'USERS' and er.role_id = and r.code =  'Reporting Manager' and tep.emp_id = er.incharge_id and = tep.user_id").list();


How can i get the values from query?