Difference between revisions of "XML Query Tool"

From PresenceWiki
Jump to: navigation, search
(The XML Query Node)
(The XML Query Node)
Line 6: Line 6:
  
 
XML Query Nodes are re-usable, which means you can create one and re-use in multiple Tasks (or in the same Task). Changes to any instance of an XML Query will affect all other instances.
 
XML Query Nodes are re-usable, which means you can create one and re-use in multiple Tasks (or in the same Task). Changes to any instance of an XML Query will affect all other instances.
 +
 +
=== Using the XML Query Editor ===
  
 
To create an XML Query Node, right click in your task edit view and select "Create New > XML Query" from the pop-up menu. You will then be presented with the XML Query Dialog:
 
To create an XML Query Node, right click in your task edit view and select "Create New > XML Query" from the pop-up menu. You will then be presented with the XML Query Dialog:
Line 16: Line 18:
 
* '''Description''': This is a description of the query's purpose
 
* '''Description''': This is a description of the query's purpose
 
* '''XSD Location''': This is the location of the XSD document which describes the XML structure. It can be on your local network, on the internet or intranet, or at an FTP location.
 
* '''XSD Location''': This is the location of the XSD document which describes the XML structure. It can be on your local network, on the internet or intranet, or at an FTP location.
 +
 +
==== Select Items Panel ====
 +
 +
This is the panel that is used to specify which elements and / or attributes you are interested in querying. To select an element, drag it into the main list pane. Any elements beneath it in the document tree will also be included, as well as attributes.
 +
 +
Aliases will automatically be created unless you uncheck "Automatically create aliases". As with the [[SQL Query Node]] editor there are also controls to change or remove aliases.

Revision as of 18:19, 12 January 2010

The XML Query Node

This Node allows you to perform queries against XML documents and convert the results into a Data Table which is stored in the Presence Context for reference by subsequent Nodes.

In order to query an XML document, you must have access to an XSD document which describes the structure of the XML. If an XSD document is unavailable you can create your own using software such as XML Spy.

XML Query Nodes are re-usable, which means you can create one and re-use in multiple Tasks (or in the same Task). Changes to any instance of an XML Query will affect all other instances.

Using the XML Query Editor

To create an XML Query Node, right click in your task edit view and select "Create New > XML Query" from the pop-up menu. You will then be presented with the XML Query Dialog:

http://www.international-presence.com/wikidocs/images/xml_dialog_1.png

The first panel prompts the user for the following information:

  • Name: This is the name to give to this query
  • Description: This is a description of the query's purpose
  • XSD Location: This is the location of the XSD document which describes the XML structure. It can be on your local network, on the internet or intranet, or at an FTP location.

Select Items Panel

This is the panel that is used to specify which elements and / or attributes you are interested in querying. To select an element, drag it into the main list pane. Any elements beneath it in the document tree will also be included, as well as attributes.

Aliases will automatically be created unless you uncheck "Automatically create aliases". As with the SQL Query Node editor there are also controls to change or remove aliases.