Clicking this action will open a dialog with all the defined database connections:
Select Database Table Dialog
The Import Criteria dialog will open next, with a default query string in the SQL Query pane:
Import from Database Criteria Dialog
The dialog contains the following items:
The SQL Query string is editable. You can specify which fields should be taken into consideration.
If the query string represents a join operation of two or more tables and columns selected from different tables have the same name you should use aliases for them, like the following example. This will avoid the confusion of two columns being mapped to the same name in the result document of the importing operation.
select s.subcat_id, s.nr as s_nr, s.name, q.q_id, q.nr as q_nr, q.q_text from faq.subcategory s, faq.question q where ...The input data will be displayed in a tabular form in the Import Settings panel. The XML Import Preview panel will contain an example of what the generated XML will look like.