Xml Database Query

Fetches data from XML database and loads into the dropdown control.

Query¶

Write your xQuery script here.

Parameters¶

Options of which database to query and parameter assignments.

Repository
Select the location of data to query, either Domain or Process repository.

Parameters

Name : Parameter name to be used in the xQuery.
Value : Xpath for parameter data to be assigned.

Results¶

Options to map and format the result data.

Item XPath
Specifies item that will be listed in dropbox. If it is left empty, which is same with * value, all resulting items are being listed.

List Item Formatting¶

Customizes format of query result.

Display Text Format
Specify the format to display result text. You can use XPath inside curly braces. Ex: {{name}} - {{id}}

Value Format
Specify the format of value. You can use XPath inside curly braces. Ex: {{id}} - {{type}}

Selection Mappings¶

In order to map the selected data from xQuery result into a node of the form, create a mapping by pressing Add New button.

Source
Node name to map its data.

Target
XPath to map data into.

Hierarchy XPath
In a nested xml node structure, for example if your XML looks like the excerpt below, you may specify the starting node of the recurrence. In this example Hierarchy XPath is "Folders".

<Folders>
    <Folder>
        <Name>folder1</Name>
    </Folder>
    <Folder>
        <Name>folder2</Name>
        <Folders>
            <Folder>
                <Name>folder2a</Name>
            </Folder>
            <Folder>
                <Name>folder2b</Name>
            </Folder>
        </Folders>
    </Folder>
</Folders>