Integration

Hi All,

i want to perform QueryTasks Operation on TaskQueryService using the WSDL Provided by Workflow Services.

http://localhost:8001/integration/services/TaskQueryService/TaskQueryService?WSDL

i would like to fetch all the tasks assigned to a grop and ignore the Acquired tasks .
i tried to formulate a Query as Shown Below

select title,assignees from wftask
where assignees like '%Supervisor%'
and (NVL(substate,'#DEF#') != 'ACQUIRED' or substate IS NULL )

this should return the tasks where substate not ACQUIRED and substate IS NULL.

Any help on how to build predicate to queryTasks for the above would be of great help

i was using SOAPUI to test the funtionality

please see the same SOAP request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tas="http://xmlns.oracle.com/bpel/workflow/taskQueryService"
xmlns:com="http://xmlns.oracle.com/bpel/workflow/common" xmlns:tas1="http://xmlns.oracle.com/bpel/workflow/taskQuery">
<soapenv:Header/>
<soapenv:Body>
<tas:taskListRequest>
<com:workflowContext>
<com:credential>
<com:login>jcooper</com:login>
<com:password>welcome1</com:password>
<com:identityContext>jazn.com</com:identityContext>
</com:credential>
</com:workflowContext>
<tas1:taskPredicateQuery startRow="0" endRow="0">
<tas1:displayColumnList>
<tas1:displayColumn>CREATOR</tas1:displayColumn>
<tas1:displayColumn>TITLE</tas1:displayColumn>
<tas1:displayColumn>CREATEDDATE</tas1:displayColumn>
<tas1:displayColumn>EXPIRATIONDATE</tas1:displayColumn>
<tas1:displayColumn>PRIORITY</tas1:displayColumn>
<tas1:displayColumn>TASKNUMBER</tas1:displayColumn>
<tas1:displayColumn>OUTCOME</tas1:displayColumn>
</tas1:displayColumnList>
<tas1:predicate>
<tas1:assignmentFilter>Group</tas1:assignmentFilter>
<tas1:clause joinOperator="AND" ignoreCase="false">
<tas1:column>TITLE</tas1:column>
<tas1:operator>EQ</tas1:operator>
<tas1:value>XYZ</tas1:value>
</tas1:clause>
<tas1:clause joinOperator="AND" ignoreCase="false">
<tas1:column>assignees</tas1:column>
<tas1:operator>CONTAINS</tas1:operator>
<tas1:value>Supervisor</tas1:value>
</tas1:clause>
<tas1:clause joinOperator="AND" ignoreCase="false">
<tas1:column>state</tas1:column>
<tas1:operator>EQ</tas1:operator>
<tas1:value>ASSIGNED</tas1:value>
</tas1:clause>
</tas1:predicate>
</tas1:taskPredicateQuery>
</tas:taskListRequest>
</soapenv:Body>
</soapenv:Envelope>


Thanks
Nadh