How to access all the tasks by task ids in In Clause with All Process Varibles

[jyotibhushan]

Problem Statement :-

Saying that I have 10 task ids and need to access all the task with all process variable in a single DB hit? How can i do this? does Activiti provides any API? Please help.

[jbarrez]

No, we don't have a query by multiple id. But you can always fall back to a native query in that case.