The XQuery Designer allows complex XQueries and XPath statements to be executed against the Report Data Source. XQuery is a query and functional programming language that is designed to query and transform collections of structured and unstructured Data, usually in the form of XML (Extensible Markup Language).
The XQuery Designer shows a logical view of the XML Data in a tree-view and the XQuery Commands provides the means to extract and manipulate Data from the Report Data Source.
Data can be queried using XQuery Commands and the Data Results viewed.
Selecting a node in the Data Tree will update the current XPath for that node. The XPath expression can then be used to query the Report Data Source.
XSD Diagrams allow a visual representation of an XPath expression in the Data Schema. Click the Diagram tab and expand out the Diagram elements to show the structure of the Data Schema.
The XPath expression for the current element is shown in the XPath navigation bar. Elements can also be navigated using the navigation buttons.
Inserting an XQuery Function
Predefined XQuery Functions can be inserted into the XQuery using the Function Tool.
XQuery contains a superset of XPath expression syntax to address specific parts of an XML document.
The language is based on the XQuery and XPath Data Model (XDM) which uses a tree-structured model of the information content of an XML document.
Inserting an XPath
XPath can be used to navigate through elements and attributes in an XML document. XPath is a syntax for defining parts of an XML document and can be inserted by navigating the Data Tree or using the Insert Tool from the menu Insert | XPath.
XPath uses path expressions to navigate in XML documents. Click Insert to add the current XPath expression to the XQuery Designer.
Report Namespaces are used for providing uniquely named elements and attributes and is a mechanism to avoid name conflicts by differentiating elements or attributes within an XML document that may have identical names, but different definitions. If the Report Data Source contains Namespaces they can be applied to the XQuery Processor.
To add Namespaces open the Report properties and select Namespaces from the property page. Add a Namespace, Prefix and URI to the Collection Editor to reflect the Namespaces in the XML Data Source.