Designer > Data Manipulation > Using the Query Builder
  

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:
  1. 1. In the Properties view for an assign activity, select Copy operations.
  2. 2. In the Copy Operations dialog, select Variable from the Type field.
  3. 3. If desired, for easier query building, select a Part.
  4. 4. Click Query Builder.
  5. 5. 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:
  6. 6. Select the variable parts, functions and operators from the boxes to build a query, following these tips:
  7. 7. Select Evaluate to substitute a sample value for a variable part and simplify the expression to view its value.