HuiSheng Xu [http://community.jboss.org/people/rebody] replied to the discussion "Historytask query" To view the discussion, visit: http://community.jboss.org/message/546010#546010 -------------------------------------------------------------- Hi zhiyong, search by process definition infor is more complicated.  Please there is no table for process definition, and the id, key, name, version column was stored in the deploy_prop table.  I am afraid you have to use lots of 'join' to achieve this. And if you want to get Session, please use this: EnvironmentImpl.getFromCurrent(Session.class); before using this, please make sure you have already open an Environment. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/546010#546010] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]