RISE to Bloome Software
Log In    
Home
RISE
Marshal
Download
 
 
r2bsoftware.se r2bsoftware.se
 
 
 
Click to hide navigation tree
Query Properties 

The Query Node

 
The query nodes have three categories of properties, XML, Harvester and Import. The harvester properties describe how data is harvested from the source system, the XML properties describe how the data is stored in the resulting Xml file, and the import properties describe how the retrieved data, or portions thereof, is transferred to another system. 

Query Nodes can contain Query Nodes, Placeholders and Leaves. You add a Query Node by right clicking on the node where you want to add a Query Node and select New Query.
 

The XML Properties


The Query Node XML Properties
Image 1, The Query Node XML Properties

Creation
Max Occurrences You may specify the maximum number of times the node may occur in the export. This information is used when generating an XSD file for your model. The default value is Unbounded.
Min Occurrences You may specify the minimum number of times the node may occur in the export. This information is used when generating an XSD file for your model. The default value is Zero.
Type Auto (default): The element is created at export as a result of harvesting. Manual: The element/attribute or any sub elements/attributes will not be created at export as a result of harvesting, but can optionally be added at a later time by e.g. a post processor or a leaf data parser. Manually added elements/attributes may be used to define import jobs.
Parent relation
Relation Every query node (except for the root node), independent of which harvester it uses, has a parent relation property in the XML section. Here you describe how this query node is related to the parent query node. To add or edit a parent relation, select the property and click on the ellipsis button. For query nodes using HTTP-harvesters, you can also relate the nodes using tags in the service url:s. Please see the appropriate harvester documentation for more information about relating nodes.
XML
Element The name of the Xml Element in the resulting XML document.
Export Specify whether the node should be saved to the Xml document. Setting the property to false means that the data of the node is available during execution, e.g. for relations and data processors, but it will not be exported to XML.
Prefix Select the XML namespace prefix for your node. All namespaces added to the root node are available to use. By default, the node uses the same prefix as its parent.


The Harvester properties

The Harvester combo box item is named after the currently selected harvester. The default harvester is the ODBC database harvester, i.e. when you create a Query-node, an ODBC database harvester is automatically added to the node. All harvesters have their own set of properties, please see the Harvesters article for information about the different harvesters and their respective properties. 

The Query Node Harvester Properties
Image 2, The Query Node Harvester Properties



The Import properties

Import rules can be added to all query nodes, including the root node. This means that every query node can have rules for importing information to one or more databases. To add Import Rules for a Query Node, click on the Import Rules property for the node and click on the ellipsis button. For more information, please read the Import article.

The Query Node Import Properties
Image 3, The Query Node Import Properties