How to use the Human WorkFlow Web Services

最新推荐文章于 2024-07-20 20:04:43 发布

iteye_2353

最新推荐文章于 2024-07-20 20:04:43 发布

阅读量164

点赞数

文章标签：数据库 java runtime

How to use the Human WorkFlow Web Services

There are different ways to interact with the Human WorkFlow services of the Oracle SOA Suite or BPM. You can use java and use it in your own application, like I did in this blogpost,use the BPM Worklist application or invoke the Human WorkFlow web services.

In this blogpost I will describe how you can do that andespeciallyhow you can query the Human task with your own ordering and restrictions.

You can try these examples from soapUI or any other web service framework / tool.

In this blogpost we will invoke these two WF web services

TaskQueryService, This WS can be used for task retrieval or do a query on the WorkFlow service.
The WSDL url = http://soa-server:8001/integration/services/TaskQueryService/TaskQueryService?WSDL

TaskService, This WS can be used for CRUD actions on the human tasks.
The WSDL url =http://soa-server:8001/integration/services/<wbr>TaskService/TaskServicePort?<wbr>WSDL<br><br> Both services got two endpoints,<span></span><strong>be aware you should always use the endpoint of TaskQueryServicePort</strong>and not the SAML port unless you like to use SAML authentication.<br><br><br><div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><service name="TaskQueryService"></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><port name="<wbr>TaskQueryServicePortSAML" binding="tns:<wbr>TaskQueryServiceSOAPBinding"></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><soap:address location="http://172.16.0.4:<wbr>8001/integration/services/<wbr>TaskQueryService/<wbr>TaskQueryService2/*"/></wbr></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"></port></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"><port name="TaskQueryServicePort" binding="tns:<wbr>TaskQueryServiceSOAPBinding"></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"><soap:address location="http://172.16.0.4:<wbr>8001/integration/services/<wbr>TaskQueryService/<wbr>TaskQueryService"/></wbr></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"></port></span></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"></service></div> <br><br> When we know our Human TaskId ( something like this 3fa4e9f7-5719-4efa-8215-ad2b47fcbace )<br> then you can use the<span></span><strong>getTaskDetailsById</strong><span></span>operation.<br><br><br><div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><soapenv:Envelope xmlns:soapenv="<a target="_blank" href="http://schemas.xmlsoap.org/soap/envelope/" style="color:rgb(17,85,204); text-decoration:none">http://schemas.<wbr>xmlsoap.org/soap/envelope/</wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQueryService" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQueryService</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:com="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/common" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>common</wbr></wbr></a>"></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Header/></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Body></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#222222"> <</span><span style="color:blue">tas:taskDetailsByIdRequest</span><span style="color:#222222">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <com:workflowContext></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <com:credential></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <com:login></span><strong><span style="color:#20124d">weblogic</span></strong><span style="color:red"></com:<wbr>login></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <com:password></span><strong><span style="color:#20124d">weblogic1</span></strong><span style="color:red"></com:<wbr>password></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </com:credential></span></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:workflowContext></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#222222"> <tas:taskId></span><span style="color:blue">3fa4e9f7-5719-<wbr>4efa-8215-ad2b47fcbace</wbr></span><span style="color:#222222"></tas:</span><wbr><span style="color:#222222">taskId></span></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas:taskDetailsByIdRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"></soapenv:Envelope></div> <br><br> In this case I use workflowContext for authentication. You can also do it on behalf of someone else.<br><br> Sometimes you only got a Human WorkFlow number then you can use the<span></span><strong>getTaskDetailsByNumber</strong><span></span>operation.<br><br><br><div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><soapenv:Envelope xmlns:soapenv="<a target="_blank" href="http://schemas.xmlsoap.org/soap/envelope/" style="color:rgb(17,85,204); text-decoration:none">http://schemas.<wbr>xmlsoap.org/soap/envelope/</wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQueryService" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQueryService</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:com="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/common" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>common</wbr></wbr></a>"></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Header/></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Body></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#222222"> <span></span></span><span style="background-color:white"><span style="color:#222222"><</span><span style="color:blue">tas:<wbr>taskDetailsByNumberRequest</wbr></span><span style="color:#222222">></span></span> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:login>weblogic</com:<wbr>login></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:password>weblogic1</com:<wbr>password></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:workflowContext></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#222222"> <tas:taskNumber></span><span style="color:blue">200000</span><span style="color:#222222"></tas:</span><wbr><span style="color:#222222">taskNumber></span></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas:<wbr>taskDetailsByNumberRequest></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"></soapenv:Envelope></div> <br><br> When you don't know the taskId or the task number or want to do bulk operations then you can do a search on the humantask services. The<span></span><strong>queryTasks</strong><span></span>operation is verypowerfuland there is not really a restriction.<br><br> let's start with a simple one. In this request I want to search for a task number and also want to have some extra attributes ( blue part ) in the response together with the Comments, Attachments and the Payloads ( red part ).<br><br><div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><soapenv:Envelope xmlns:soapenv="<a target="_blank" href="http://schemas.xmlsoap.org/soap/envelope/" style="color:rgb(17,85,204); text-decoration:none">http://schemas.<wbr>xmlsoap.org/soap/envelope/</wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQueryService" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQueryService</wbr></wbr></a>" \</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:com="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/common" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>common</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas1="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQuery" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQuery</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:task="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/task" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/task</wbr></a>"<wbr>></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Header/></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:login>weblogic</com:<wbr>login></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:password>weblogic1</com:<wbr>password></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskPredicateQuery></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:displayColumnList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:displayColumn><wbr>textAttribute1</tas1:<wbr>displayColumn></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:displayColumn><wbr>textAttribute2</tas1:<wbr>displayColumn></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:displayColumn><wbr>textAttribute3</tas1:<wbr>displayColumn></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:displayColumnList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:optionalInfoList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:taskOptionalInfo><wbr>Comments</tas1:<wbr>taskOptionalInfo></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:taskOptionalInfo><wbr>Attachments</tas1:<wbr>taskOptionalInfo></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:taskOptionalInfo><wbr>Payload</tas1:<wbr>taskOptionalInfo></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </tas1:optionalInfoList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span></span><span style="color:#20124d"> <tas1:predicate></span></strong></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span> <span></span></span><span style="background-color:white"><span style="color:blue"><tas1:assignmentFilter>All</<wbr>tas1:assignmentFilter></wbr></span></span></strong></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span style="color:#20124d"> <tas1:clause></span></strong></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span style="color:#20124d"> <tas1:column>taskNumber</tas1:<wbr>column></wbr></span></strong></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span style="color:#20124d"> <tas1:operator>EQ</tas1:<wbr>operator></wbr></span></strong></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span style="color:#20124d"> <tas1:value>200001</tas1:<wbr>value></wbr></span></strong></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span style="color:#20124d"> </tas1:clause></span></strong></div> <div style="font-family:arial,sans-serif; font-size:13px"><strong><span style="color:#20124d"> </tas1:predicate></span></strong></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:taskPredicateQuery></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </soapenv:Body></div> <span style="font-family:arial,sans-serif; color:#222222; font-size:13px"></soapenv:Envelope></span><br><br> In the<span></span><strong>predicate</strong><span></span>part we are using the old style for defining our restriction ( clause after predicate ). In the next queryTasks examples I will show the ones which also will be supported in the coming soa suite releases. <span></span><br><br><strong>assignmentFilter</strong><span></span>can have the following values: All, My, Group, My+Group, My+Group+All, Reportees, Creator, Owner, Previous, Admin<br><br><strong>operator</strong><span></span>can have the following values:EQ, NEQ, GT, GTE, LT, LTE, LIKE, NOT_LIKE, IN, NOT_IN, CONTAINS, NOT_CONTAINS, BEGINS, NOT_BEGINS, ENDS, NOT_ENDS, BEFORE, AFTER, ON, NEXT_N_DAYS, LAST_N_DAYS, IS_IN_FUTURE, IS_IN_PAST, IS_NULL, IS_NOT_NULL<br><div><br></div> To know all the possible<span></span><strong>displayColumn</strong><span></span>values you can decompile the<span></span><strong>TableConstants</strong><span></span>class located in the<strong>oracle.bpel.services.workflow.repos</strong><span></span>package. Or look at the WF tables in the soa-infra schema.<br><br> The<span></span><strong>optionalInfoList</strong><span></span>can contain the following values: Actions, GroupActions, CustomActions, Attachments, Comments, Payload, ShortHistory, TemplateTasks<br><br> In this query I have a predicate with two clauses which do a search on the text attributes ( tableName attribute is in almost all cases WFTask , check the soa-infa database or the TableConstants class ) and the second one has an AND operator on the first one.<br><br><br><div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><soapenv:Envelope xmlns:soapenv="<a target="_blank" href="http://schemas.xmlsoap.org/soap/envelope/" style="color:rgb(17,85,204); text-decoration:none">http://schemas.<wbr>xmlsoap.org/soap/envelope/</wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQueryService" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQueryService</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:com="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/common" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>common</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas1="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQuery" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQuery</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:task="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/task" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/task</wbr></a>"<wbr>></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Header/></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:login>weblogic</com:<wbr>login></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:password>weblogic1</com:<wbr>password></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskPredicateQuery startRow="1" endRow="10"></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumnList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute1</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute2</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute3</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:displayColumnList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:optionalInfoList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Comments</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Attachments</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Payload</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:optionalInfoList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:predicate></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:assignmentFilter>All</<wbr>tas1:assignmentFilter></wbr> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#222222"> <span></span></span><span style="color:blue"><tas1:predicate></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:column tableName="</span><strong><span style="color:#20124d">WFTask</span></strong><span style="color:blue">"></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:columnName></span><wbr><strong><span style="color:#20124d">textAttribute1</span></strong><span style="color:blue"></tas1:</span><wbr><span style="color:blue">columnName></span></wbr></wbr> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:column></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:operator></span><strong><span style="color:#20124d">EQ</span></strong><span style="color:blue"></tas1:<wbr>operator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:value>MyTask</tas1:<wbr>value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:clause</span><span style="color:#20124d"><span></span><strong>joinOperator="AND"</strong></span><span style="color:blue">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:column tableName="</span><strong><span style="color:#20124d">WFTask</span></strong><span style="color:blue">"></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:columnName></span><wbr><strong><span style="color:#20124d">textAttribute2</span></strong><span style="color:blue"></tas1:<wbr>columnName></wbr></span></wbr> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:column></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:operator></span><strong><span style="color:#20124d">EQ</span></strong><span style="color:blue"></tas1:<wbr>operator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:value>1234</tas1:value></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:predicate></span></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:predicate></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:taskPredicateQuery></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"></soapenv:Envelope></div> <br><br> In the next example we will add some ordering and use a valuelist in a predicate clause ( for this we need to use the IN operator).<br><br><br><div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><soapenv:Envelope xmlns:soapenv="<a target="_blank" href="http://schemas.xmlsoap.org/soap/envelope/" style="color:rgb(17,85,204); text-decoration:none">http://schemas.<wbr>xmlsoap.org/soap/envelope/</wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"> </span>xmlns:tas="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQueryService" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQueryService</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"> </span>xmlns:com="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/common" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>common</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"> </span>xmlns:tas1="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQuery" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQuery</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"> </span>xmlns:task="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/task" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/task</wbr></a>"<wbr>></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Header/></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:login>weblogic</com:<wbr>login></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:password>weblogic1</com:<wbr>password></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskPredicateQuery></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumnList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute1</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute2</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute3</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:displayColumnList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:optionalInfoList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Comments</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Attachments</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Payload</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:optionalInfoList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:predicate></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:assignmentFilter>My+<wbr>Group</tas1:assignmentFilter></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:predicate></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:column tableName="</span><strong><span style="color:#20124d">WFTask</span></strong><span style="color:blue">"></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:columnName></span><strong><span style="color:#20124d">state</span></strong><span style="color:blue"></tas1:<wbr>columnName></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:column></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:operator></span><strong><span style="color:#20124d">IN</span></strong><span style="color:blue"></tas1:<wbr>operator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:valueList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:value>ASSIGNED</tas1:<wbr>value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:value>INFO_REQUESTED</<wbr>tas1:value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> <tas1:value>OUTCOME_UPDATED</<wbr>tas1:value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:valueList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:predicate></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:predicate></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:ordering></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:column></span><strong><span style="color:#20124d">priority</span></strong><span style="color:red"></tas1:<wbr>column></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:table></span><strong><span style="color:#20124d">WFTask</span></strong><span style="color:red"></tas1:<wbr>table></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:sortOrder></span><strong><span style="color:#20124d">ASCENDING</span></strong><span style="color:red"></<wbr>tas1:sortOrder></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:nullFirst>false</tas1:<wbr>nullFirst></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:column></span><strong><span style="color:#20124d">taskNumber</span></strong><span style="color:red"></tas1:<wbr>column></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:table></span><strong><span style="color:#20124d">WFTask</span></strong><span style="color:red"></tas1:<wbr>table></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:sortOrder></span><strong><span style="color:#20124d">DESCENDING</span></strong><span style="color:red"></<wbr>tas1:sortOrder></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:nullFirst>false</tas1:<wbr>nullFirst></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </tas1:ordering></span></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:taskPredicateQuery></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"></soapenv:Envelope></div> <div><br></div> <br> For the Ordering I need to provide the column and table values (table element is in almost all cases WFTask , check the soa-infa database or the TableConstants class)<br><br> The last query task has a more complex predicate, for this we need to use lhs , logicalOperator and rhs elements. And the rhs element contains an another lhs , logicalOperator and rhs section.<br><br><br><div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"><soapenv:Envelope xmlns:soapenv="<a target="_blank" href="http://schemas.xmlsoap.org/soap/envelope/" style="color:rgb(17,85,204); text-decoration:none">http://schemas.<wbr>xmlsoap.org/soap/envelope/</wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQueryService" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQueryService</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:com="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/common" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>common</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:tas1="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/taskQuery" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/<wbr>taskQuery</wbr></wbr></a>"</div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <span style="white-space:pre-wrap"></span>xmlns:task="<a target="_blank" href="http://xmlns.oracle.com/bpel/workflow/task" style="color:rgb(17,85,204); text-decoration:none">http://xmlns.<wbr>oracle.com/bpel/workflow/task</wbr></a>"<wbr>></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Header/></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:login>weblogic</com:<wbr>login></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <com:password>weblogic1</com:<wbr>password></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:credential></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </com:workflowContext></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskPredicateQuery startRow="1" endRow="10"></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumnList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute1</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute2</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:displayColumn><wbr>textAttribute3</tas1:<wbr>displayColumn></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:displayColumnList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:optionalInfoList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Comments</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Attachments</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:taskOptionalInfo><wbr>Payload</tas1:<wbr>taskOptionalInfo></wbr></wbr> </div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:optionalInfoList></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:predicate></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> <tas1:assignmentFilter>My+<wbr>Group</tas1:assignmentFilter></wbr> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#222222"> </span><span style="color:blue"><span></span> <tas1:predicate></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:</span><strong><span style="color:#20124d">lhs</span></strong><span style="color:blue">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:column tableName="WFTask"></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:columnName>state</tas1:<wbr>columnName></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </tas1:column></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:operator></span><strong><span style="color:#20124d">IN</span></strong><span style="color:red"></tas1:<wbr>operator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:valueList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:value>ASSIGNED</tas1:<wbr>value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:value>INFO_REQUESTED</<wbr>tas1:value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> <tas1:value>OUTCOME_UPDATED</<wbr>tas1:value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </tas1:valueList></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:red"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> </tas1:</span><strong><span style="color:#20124d">lhs</span></strong><span style="color:blue">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:logicalOperator></span><strong><span style="color:#20124d">AND</span></strong><span style="color:blue"></<wbr>tas1:logicalOperator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> <tas1:</span><strong><span style="color:#20124d">rhs</span></strong><span style="color:blue">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> </span><span style="color:red"><tas1:</span><strong><span style="color:#20124d">lhs</span></strong><span style="color:red">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <span></span></span><span style="color:#20124d"><tas1:clause></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> <tas1:column tableName="WFTask"></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> <tas1:columnName><wbr>textAttribute1</tas1:<wbr>columnName></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> </tas1:column></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#20124d"> <tas1:operator></span><strong><span style="color:#20124d">EQ</span></strong><span style="color:#20124d"></tas1:<wbr>operator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> <tas1:value>MyTask</tas1:<wbr>value></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#20124d"> <tas1:clause joinOperator="</span><strong><span style="color:#20124d">AND</span></strong><span style="color:#20124d">"></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> <tas1:column tableName="WFTask"></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> <tas1:columnName><wbr>textAttribute2</tas1:<wbr>columnName></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> </tas1:column></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#20124d"> <tas1:operator></span><strong><span style="color:#20124d">EQ</span></strong><span style="color:#20124d"></tas1:<wbr>operator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> <tas1:value>1234</tas1:value></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#20124d"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> </tas1:</span><strong><span style="color:#20124d">lhs</span></strong><span style="color:red">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:logicalOperator></span><strong><span style="color:#20124d">OR</span></strong><span style="color:red"></<wbr>tas1:logicalOperator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> <tas1:</span><strong><span style="color:#20124d">rhs</span></strong><span style="color:red">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#73763"> <tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#73763"> <tas1:column tableName="WFTask"></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#73763"> <tas1:columnName><wbr>textAttribute2</tas1:<wbr>columnName></wbr></wbr></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#73763"> </tas1:column></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:#73763"> <tas1:operator></span><strong style="background-color:white"><span style="color:#20124d">EQ</span></strong><span style="color:#73763"></tas1:<wbr>operator></wbr></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#73763"> <tas1:value>123</tas1:value></span></div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:#73763"> </tas1:clause></span></div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:red"> </tas1:</span><strong><span style="color:#20124d">rhs</span></strong><span style="color:red">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"> <span style="color:blue"> </tas1:</span><strong><span style="color:#20124d">rhs</span></strong><span style="color:blue">></span> </div> <div style="font-family:arial,sans-serif; font-size:13px"><span style="color:blue"> </tas1:predicate></span></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:predicate></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas1:taskPredicateQuery></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </tas:taskListRequest></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"> </soapenv:Body></div> <div style="font-family:arial,sans-serif; color:rgb(34,34,34); font-size:13px"></soapenv:Envelope></div> <br><br><br> At last we can also try update a Task with a particular outcome. For this we need to use the TaskService<span></span><br> http://soa-server:8001/integration/services/<wbr>TaskService/TaskServicePort?<wbr>WSDL<br><br> Use the right endpoint ( not the SAML one ) and use the operation<span></span><strong>updateTaskOutcome<span></span></strong>( this is the easiest way )<br><br><br> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"<br> xmlns:tas="http://xmlns.oracle.com/bpel/workflow/taskService"<br> xmlns:com="http://xmlns.oracle.com/bpel/workflow/common"<br> xmlns:task="http://xmlns.oracle.com/bpel/workflow/task"<br> xmlns:tas1="http://xmlns.oracle.com/bpel/workflow/TaskEvidenceService"><br> <soapenv:Header/><br> <soapenv:Body><br> <tas:updateTaskOutcome><br> <com:workflowContext><br> <com:credential><br> <com:login>humantask</com:login><br> <com:password>Welcome01</com:password><br> </com:credential><br> </com:workflowContext><br> <tas:taskId><span style="color:blue"><strong>3e80842f-75c9-4e3d-b441-a7f339df4109</strong></span></tas:taskId><br> <tas:outcome><span style="color:blue"><strong>OK</strong></span></tas:outcome><br> </tas:updateTaskOutcome><br> </soapenv:Body><br> </soapenv:Envelope><br><br><br><br> Just provide the taskId and what the outcome should be. <div style="clear:both"></div> </wbr></wbr></wbr></wbr>

40 comments:

Anonymous April 11, 2012 at 2:26 AM

Hi Edwin, the end point /integration/services/TaskQueryService/TaskQueryServicePort?WSDL gives a 404 error for me.
/integration/services/TaskQueryService/TaskQueryService?WSDL is available but I get :
...
ns0:InvalidSecurity
InvalidSecurity : error in processing the WS-Security security header

...

Is this the SAML issue?
Mark
Reply

Replies
Edwin Biemond April 11, 2012 at 9:08 PM

Hi,

Do you get this error in soapui when invoking a request or with loading the wsdl.

in soapui you can change the endpoint on the top of the request.

thanks
Anonymous April 12, 2012 at 1:17 AM

Thanks for your response. I managed to get the service working. I think my problem was not calling the authenticate service first and using the token passed back in subsequent calls.

Successful payload for me;

a075f524-53ef-4713-82e7-0145ad3853bf;;i1sDxUH6FW/5af/QlrBMDlOdu8YG65+CfbSd0fMpkOfZWUHxdUwEsV6LM3gH8c3Ic1kSNT17LPxp8kOO6uZ1LQAy2zrwa5mX9e08I01Cp8RjIPnB0k8idpIt21+Pv+tS7xsEeNBHWhASDszU/pzZONbKcYsu1auQmTEMw0iEnuCrP5PWa8t8iar/vg3CdxSCPFhhQVcNUHjAoQaIJB2ppGu7+sFyHrBPwM/TCLwsz0udQXEOT+h4uLoy/5v0uiDg

All

State
EQ
ASSIGNED

Note I could not access the endpoint .../TaskQueryServicePort?WSDL you mentioned so I'm using /TaskQueryService?WSDL We are running SOA suite 11.1.1.4.

Thanks Mark
Edwin Biemond April 12, 2012 at 3:58 PM

Hi,

I also running PS3 and everything is working fine and I don't need a token. just can use username / password
Also both wsdl url are working on PS3.

TaskQueryService, This WS can be used for task retrieval or do a query on the WorkFlow service.
The WSDL url = http://soa-server:8001/integration/services/TaskQueryService/TaskQueryService?WSDL

TaskService, This WS can be used for CRUD actions on the human tasks.
The WSDL url = http://soa-server:8001/integration/services/TaskService/TaskServicePort?WSDL

thanks

Anonymous April 12, 2012 at 3:44 PM

Edwin, are you able to get the getDisplayURL() method to work for the TaskQueryService?

Vivek

Replies

Edwin Biemond April 12, 2012 at 3:59 PM

Hi,

What is getDisplayURL , is that an wsdl operation

thanks

Anonymous April 12, 2012 at 6:00 PM

Sorry, I meant to ask this in relation to a task obtained using getTaskDetailsById or getTaskDetailsByNumber. All task details area available except for task.getDisplayURL().

Edwin Biemond April 16, 2012 at 8:30 PM

I think it is a fixed url with a taskId parameter.

you can check it in the EM instance process when you click on the humantask. it will give you a direct link to the worklist app.

thanks

Anonymous May 8, 2012 at 10:58 PM

I agree its a fixed URL...comes from the WorkFlowUtil class. The question is: should the task api which has this method return a fixed url.
I can check EM and get the URL. How does one solve this problem in code when a random task has to be opened?
Thanks
Vivek

Srini April 15, 2012 at 6:59 PM

Hi Edwin,

I am using BPEL human task API - createTask/initiateTask API in particular to create a new task. I am able to do this. Now I am trying to create a task with multiple owners - tried this using the setOwner() method on Task object and also tried comma separated owners through the payload - Both does not seem to work :(.

Replies

Edwin Biemond April 16, 2012 at 8:15 PM

Hi,

you can assign to multiple groups or users but I think there can only be one process owner.

thanks

gleantech April 20, 2012 at 3:06 PM

It is really nice and informative, it is useful for me. thank you

a-men August 28, 2012 at 2:43 PM

Hi Edwin,

did you ever try to initiate a task via the "initiateTask" web service operation?
I think I'm missing something here: I'm able to create (and submit) an initiate task instance this way, but here is no (SCA) process instance created for this task.

In addition, this works without providing credentials (as you have to do in all the other operations).

<soapenv:Envelope ...>
<soapenv:Header/>
<soapenv:Body>
<tas:initiateTask>
<task:task>
<task:title>My Task, just created</task:title>
<task:payload></task:payload>
<task:priority>3</task:priority>
<task:taskDefinitionURI>default/SimpleBPM!1.0/Humantask1</task:taskDefinitionURI>
<task:creator>weblogic</task:creator>
<task:ownerUser>weblogic</task:ownerUser>
</task:task>
</tas:initiateTask>
</soapenv:Body>

Replies

Edwin Biemond September 2, 2012 at 10:11 PM

Hi,

I never, always use it with BPEL so I can react on the outcome. Initiate without bpel only works I guess in the Worklist application and in combination with BPM where WF is the starting of a process.

thanks

Vivek November 22, 2012 at 3:10 PM

Hi Edwin,

Do you know if the Task Title can be updated?

Thanks,
Vivek

Replies

Edwin Biemond November 24, 2012 at 1:27 PM

Hi,

I think it should be possible , you can assign it to a payload variable when you create the HWF from BPEL or try to use the TaskService WS/ EJB

thanks

Vivek November 26, 2012 at 7:26 AM

Hi Edwin,

Thanks a lot for the reply.

I tried both the approaches:
- Assigning a payload variable to the title did give me the correct title after the task was initiated. However, after that when the payload variable changed (using the updateTask WS call), the task title remained the same.
- When I tried to change the Title directly using the WS call, it did not update (other attributes like priority were updated successfully).

Is there anything else I can try?

Thanks for the help,
Vivek

Edwin Biemond December 2, 2012 at 12:47 PM

Hi,

I think you tried it all , maybe you can ask for a SR or ER on oracle support.

thanks

Edwin Biemond December 2, 2012 at 12:48 PM

By the way,

not supported by Oracle , all data is in the WF Tasks table , find the right row with the task id as primary key and update the title.

Vivek December 4, 2012 at 6:48 PM

Thanks Edwin, will try out that suggestion.

An unrelated question: What can I do so that weekends are ignored for for expiration? Do I need to create a new Calendar Rule in BPM workspace? Is there any other way?

Thanks,
Vivek

Vivek December 5, 2012 at 7:54 PM

Hi Edwin,

With Regards to Task Title, a DB update on the WFTask_TL title worked.
Thanks a ton for the tip.

- Vivek

Daniel Ribeiro January 4, 2013 at 2:08 PM

Biemond Hello, I can not introspect the WSDL http://host:port/integration/services/TaskService/TaskServicePort?WSDL in jdev 11.1.1.6 (PS5). The endpoint is pointing to SOA 11.1.1.6 (PS5).
But I can introspect the same endpoint in jdev 11.1.1.5 (PS4). Seems to be a product problem. Know it?

Replies

Daniel Ribeiro January 4, 2013 at 2:17 PM

I´m using Windows 7 O.S.

Edwin Biemond January 9, 2013 at 10:08 PM

Hi,

For the Task and TaskQuery Services (PS5) I had to patch the soa suite. there were some problems with the workflow xsd in jdeveloper and on the server. I had to use the patch the fabric runtime jar on the server and in jdeveloper.

thanks.

Anonymous March 5, 2013 at 8:44 AM

Hi Edwin,

The post is very useful and informative.Could you please let me know how can we use the SAML configuration for these webservices.

Thanks

Replies

Edwin Biemond March 6, 2013 at 9:52 PM

Hi,

Then you need to follow thishttp://biemond.blogspot.nl/2011/08/do-saml-with-owsm.html

So make osb business service or soa reference service with an owsm saml client policy and call the saml endpoint , on the proxy or soa service side use a username token policy, call this service and add your credentials and this will passed on to the human workflow services.

Thanks
Thanks

Amit Jain November 1, 2013 at 3:02 AM

Hi Edwin, can we edit the task title when it going through multiple level of approvals? For eg. user A approves the task with title "Action Title ABC" and then goes to user B for review. In this case, when task goes to user B, can I have title set as "Review Title ABC"? Thanks in advance.

Replies

Edwin Biemond November 4, 2013 at 3:05 PM

Hi,

When I look at the Java API of humantask I can see the following methods
IWorkflowContext -> getTaskService() -> mergeAndUpdateTask and updateTask
probably the same operations for the HumanTask WebServices.

but you probably need to this yourself and listen for the approval events and call this API and set the new title.

Thanks

Makrand Pare January 5, 2014 at 7:16 AM

Hi Edwin,
Have you ever used the webservice method requestInfoForTaskWithReapproval of the TaskService ?
I am trying to use this method and all I get is this error:

INFO_REQUEST

Can you please try to invoke this service and let me know your findings?

Replies

Edwin Biemond January 19, 2014 at 12:58 PM

Hi,

what is your scenario, cause for requestInfoForTaskWithReapproval you need to have multiple approvements and next user user asks an another user which already approved this task for extra information.
that user should respond with a info request and after this the next approval user can do a UpdateTaskOutcome

Thanks

Debojit Sinha January 16, 2014 at 6:26 PM

Hi Edwin,
Sorry, to wake this thread up again, but I'm trying to invoke the SAML endpoint, with no success. Could you please advise me on how I might go about it?

Thanks

Replies

Edwin Biemond January 19, 2014 at 12:46 PM

hi,

maybe this can help. but indeed it's hard
http://biemond.blogspot.nl/2011/08/do-saml-with-owsm.html

I mostly use the java api
http://biemond.blogspot.nl/2011/10/working-with-human-worklist-api-and.html

or set in the soap call

com:workflowContext
com:credential
com:login weblogic /com:login
com:password weblogic1 com:password
/com:credential

hulk January 17, 2014 at 9:08 PM

Hi Edwin ,
I need to take an action/outcome on HumanTask (need to take Reprocess Action defined in HumanTask).
Can i achive it using these web services(using UpdateTaskOutcome) .
I am able to authenticate and take a token , please let me know which operation will allow me doing the same.
Thanks in Advance :)
Waiting for your Reply

Replies

Edwin Biemond January 19, 2014 at 12:39 PM

hi,

indeed with UpdateTaskOutcome you can achieve this

hulk January 20, 2014 at 8:43 PM

This comment has been removed by the author.

Abhishek January 20, 2014 at 10:54 PM

Thanks Edwin
It worked as suggested :) , must say Really Helpful Post

Ajral February 5, 2014 at 7:05 AM

Thanks for all your earlier responses your advices have been a great support...

In one of our requirement we have used human task with different number of stages (14 stages ) and to route the task through different stages I am using advance routing rules (30 rules),and for all this we are using only one human task component we have exposed this through bpel .

My code and process is working fine .

My question is:-

1- Do this kind of design contain flaws, is there is any restriction on using of number of stages and number of routing rules. Is there is any best practise involves which suggests that we cannot have more than certain number of stages or routing rules..??

2-Is it feasible to use different human task component for each of the human task stages and route the data using business rule, but that will be very exhausted and will unnecessarily makes bpel heavier, also the front end people need only one bpm urls this approach will make their work tedious as different number of human task component will have different urls..

Please suggest .
Thank you

Anonymous March 18, 2014 at 7:02 PM

Hi,

I want to test all the methods of the TaskService and TaskQueryService webservice.Can you please share any link containing all the input parameters for all the methods to test through SOAPUI.

Please Suggest
Thank You

Replies

asdf May 27, 2014 at 9:00 PM

It would be nice to have more examples on the interwebz, the info is almost non-existent and these xsd's are complex as hell

Ravi Kiran April 12, 2014 at 3:22 AM

Hi Biemond

How are you doing!
Your posts are really valuable to all of the SOA community.

I need a suggestion. We have a requirement where we have to expose the underlying TaskQueryService via OSB, both normal and SAML ports ( Prj requirement restricts the consumers to directly access the task information, so we are creating a service that talks to the underlying TaskQueryService and get the information)
My question is, can a single OSB Service cater to both the ports? As I see, while creating proxy or business services, it either asks for a port or binding. If I select a port, I can select only one port, so I'll end up with 2 OSB Projects(proxy & business services, one for each port). If I select the binding, I'll lose the information about ports, and in Business service, I'll have to specify the URL, so obviously here aswell, I will require 2 business services and corresponding 2 proxy services.
Is there a way where a single OSB Project can cater to expose both the ports? Just as how this wsdl is exposing both the ports?

Also, another thing is that we are told to use abstract wsdl as we are putting that in mds so that consumer will use it while calling our service which ultimately calls the TaskQueryService. So if the wsdl is abstract, and I create proxy service based on that, how can I expose both the ports?

Appreciate your help on this.

Regards
Ravi

iteye_2353

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
How to use the Human WorkFlow Web Services

How to use the Human WorkFlow Web ServicesThere are different ways to interact with the Human WorkFlow services of the Oracle SOA Suite or BPM. You can use java and use it in your own ap...
复制链接

扫一扫