Process Developer

Back Next

Filtering a Task List by Parameter using a WS-HT whereClause

You can use the following operators in the whereClause:

and

()

The following examples show various

whereClause

syntax. Note that the Booleans

and

are case-sensitive.

For a complete list of task column names, task types, generic human roles and other WS-HT specifications, you can work with the Informatica Business Process Manager SDK.

Example 1

The following example shows a sample

whereClause

using a standard WS-HT task property name.

<htdt:whereClause>Task.Name = 'ApproveLoan'</htdtwhereClause>

Example 2

The following example combines filter properties:

Task.Priority &lt; 3 and Task.Owner = ‘loanrep1'

Example 3

The following example also combines filter properties.

Task.PaProcessId = 10 
      and(Task.Escalated = true
      or  Task.Priority = 0)

Example 4:
Using Presentation Parameters (Custom Task Properties)

The following example shows using presentation parameters:

Task.Name = ‘LoanApproval' 
       and loanAmount &gt; 10000 
       and zipCode = '06484'

Configuring a GetMyTasks Filter with a WhereClause

Download Guide

Watch

Comments

Cloud Application Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Process Developer

Process Developer

Filtering a Task List by Parameter using a WS-HT whereClause

Filtering a Task List by Parameter using a WS-HT whereClause