Mapping Data to Elements and Attributes |
Elements should be associated with data. To associate an element object with data, the parent element object must contain an SQL query. The SQL query must select the table and column that will map to the child element object. After associating the parent element with an SQL query, you must associate a child element with the column.
Use the link by source structure tree operation option to associate elements with SQL queries. When you associate an element with an SQL query, use the customize dialog to associate child elements or attributes with the selected columns of the SQL query. Dragging a table from the database schema panel into a parent element in the XTT object tree will cause the customize dialog to open.
When linking element objects by source structure, the customize dialog will show the query object name, and two columns: the XTT object column, and the mapping column. The XTT object column displays all child elements and attributes of the element that you have dragged the table into. The mapping column displays any existing content, and is where you select the column content that you want to map from. Click a row in the mapping column to select an SQL data source for the corresponding XTT object.