[jboss-user] [jBPM] - Querying problem in JBPM4.4

[parvathy j a]

parvathy j a [http://community.jboss.org/people/parvathy] created the discussion

"Querying problem in JBPM4.4"

To view the discussion, visit: http://community.jboss.org/message/573992#573992

--------------------------------------------------------------
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
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/573992#573992]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101202/95f3bcc3/attachment.html