Build Queries with Drag and Drop from the Data Source Explorer View
When a query is edited in the XQuery editor, the XPath expressions can be composed quickly by dragging them from the Data Source Explorer view and dropping them into the editor panel.
- Configure the data source drivers for the particular relational database in the Data Sources preferences page.
- Configure the connection for the particular relational database in the Data Sources preferences page.
- Browse the connection in the Data Source Explorer view, expanded to the table or column that you want to insert in the query.
- Drag the table or column name to the XQuery editor panel.
- Drop the table or column name where the XPath expression is needed.
An XPath expression that selects the dragged name is inserted in the XQuery document at the cursor position.