AnsweredAssumed Answered

How can i get the values from query?

Question asked by vamsinipun on May 8, 2018

Hi Team,

 

I am using activiti in my spring web application.

 

How can i get the values from below query?

 

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 = r.id and r.code =  'Reporting Manager' and tep.emp_id = er.incharge_id and u.id = tep.user_id").list();

 

Please help me out this?

 

Thanks

Outcomes