Process Developer

Back Next

Using the Query Builder

Select from the Part, Variables, Functions, and Operators pick lists to create a query in the Query text box. Select an expression language to use for the current expression.

A copy operation in an assign activity can contain an XPath (or other selected language) query attribute that results in a string, number, or Boolean. The value of the query attribute is a query string that identifies a single value within a source or target variable part.

The Query Builder dialog is similar to the Expression Builder dialog, with the addition of a Variable Part tree for easy selection of parts.

For details on XPath syntax, see the XPath specification at

http://www.w3.org/TR/xpath.

To build a query:

In the Properties view for an assign activity, select Copy operations.

In the Copy Operations dialog, select Variable from the Type field.

If desired, for easier query building, select a Part.

Click Query Builder
.

If needed, select the

Dialog (...) Button

in the Query Language field to select a different query language URI that non-Process Developer engines support. Do the following:

In the Query Language dialog (or in the Properties view of the BPEL process), type in a different URI for a non-Process Developer configured language. The URI is ignored by Process Developer.

To restore the default, clear the URI and click OK
.

Select the variable parts, functions and operators from the boxes to build a query, following these tips:

For a shortcut, use content assist, as described in Using Content Assist

Select a variable, part, function, or operator and select Insert

Double-click a variable part to generate the location information for the query

Double-click a variable to paste the

variableReference

function into the Query box

Double-click on a branch under a part to paste the location into the Query box

Add custom functions, as described in Process Developer Custom Functions

Add your own custom functions, as described in Creating POJO and XQuery Custom Functions

Select Evaluate
to substitute a sample value for a variable part and simplify the expression to view its value.