Hi,
I would like to select all rows from tables JBPM4_HIST_ACTINST and JBPM4_TASK where JBPM4_HIST_ACTINST.HTASK_ =JBPM4_TASK.DBID_..
i have used criteria and detached criteria for this...but i dunno how to select all the rows..so that i could return it as a List<Object> rather than a List of specific table entity..
My code is
Criteria criteriaObj=session.createCriteria(HistoryTaskImpl.class);
criteriaObj.add(Restrictions.eq("assignee", userId));
criteriaObj.add(Restrictions.eq("state", status));
criteriaObj.add(Restrictions.eq("serviceName", serviceName));
criteriaObj.add(Restrictions.between("createTime", dateFrom, dateTo));
DetachedCriteria ownerCriteria = DetachedCriteria.forClass(HistoryActivityInstanceImpl.class);
ownerCriteria.setProjection(Property.forName("historyTask"));
ownerCriteria.add(Restrictions.eq("transitionType", transitionType));
criteriaObj.add(Property.forName("dbid").in(ownerCriteria));
List<Object> obj=(List<Object>)criteriaObj.list();
This would return an object which contains only HistoryTaskImpl columns..but i want HistoryActivityInstanceImpl columns also..
Plz do help in this
Thanking you
Parvathy