This procedure steps through addition of the Query Model stage to a workflow in Flow Designer. Use the Query Model stage to execute a saved Context Graph model query in a workflow.
-
In Flow Designer, on the Stages panel, expand the Context Graph section, and drag the Query Model stage to the canvas.
- Connect a source to the input port on the Context Graph stage.
-
Double-click the Query Model stage.
-
Specify the Context Graph Model and Query that you want to execute in the workflow.
-
On the Input Fields tab, you can the view input fields for the query.
-
Click the Output Fields tab to configure output from the stage.
The Query results box lists results that correspond to levels in a saved query.
-
In the Query results box, click to view the output fields corresponding to the result in the adjacent stage fields table.
You can check or uncheck boxes in the table to include or remove fields in the output. Press the Ctrl or Shift key and click another result to simultaneously view fields for more than one result.
-
To configure the settings for any result listed in Query Results box, check the Override query results check box, and click a single result to configure its settings.
-
In the Result Configuration box, you can change the result name and path, whether to use type names on the fields, and choose flat or hierarchical list output for each result.
-
When you finish configuring the stage, click the Apply button.
-
If you have not done so already, connect the output port to a downstream stage.
The Query Model stage has a single required output port that you must connect to a stage that accepts input, such as the Write to File or Write to DB stage for flat output or the Write to XML stage for hierarchical output.
-
Before exiting the workflow, be sure to click the Save button
to save the workflow.