guys, i realized that we have the end dates in the history as well. so having the end state set to 'ended' would be duplicating information that is already easy queryable. select .. | from ... | where histProcInst.state = 'ended' | | == | | select .. | from ... | where histProcInst.end is not null so i'll keep a single state in the history process instance entity. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4231796#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...