querying the workflow

[vishalj]

how to get all the workflow ids for current user
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=452279&messageID=540789#540789


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[vishalj]

Expression queryLeft = new FieldExpression(
                                  FieldExpression.NAME,
                                  FieldExpression.ENTRY,
                                  FieldExpression.EQUALS, "example");
                Expression queryRight = new FieldExpression(
                                  FieldExpression.STATE,
                                  FieldExpression.ENTRY,
                                  FieldExpression.EQUALS,4,true);
                WorkflowExpressionQuery query = new WorkflowExpressionQuery(
                          new NestedExpression(new Expression[] {queryLeft, queryRight},
                          NestedExpression.AND));  


-----------------------
but the query generated is


SELECT DISTINCT (a1.ENTRY_ID) AS retrieved
FROM OS_WFENTRY AS a1 , OS_WFENTRY AS a2  WHERE a1.ENTRY_ID = a1.ID AND a1.ID =
a2.ID AND ( a1.NAME =  ?  AND a2.STATE !=  ?  )


where is the entry_id for WF_ENTRY table
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=452279&messageID=542874#542874


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[vishalj]

I have not used queries with OSWorkflow before. I would need to have a look at the code to see how it works. It seems odd that it would generate a join on the same table.
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=452279&messageID=547689#547689


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[vishalj]

yaa it is wat happend .... any clues may be i did something in a wrong way
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=452279&messageID=558667#558667


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...