Working with a database schema and datasets

1. Open the Query data panel.
2. Navigate to the Database schema tab.
3. Expand the sections by clicking the arrows.

For each field the following is displayed:

• Name
• Data type

1. Open the Database schema tab.
2. Enter a name in the Search fields field.
3. The results will be displayed automatically.

1. Click the field in the database schema.
2. Select Insert into query.

The field name will be added to the query editor at the cursor position.

1. Open the data panel.
2. Navigate to the Datasets tab.
3. Select a dataset from the list.

For each dataset the following is displayed:

• Name.
• Description.
• List of fields with data types.

1. Open the Datasets tab.
2. Navigate to Lookup table.
3. Select a table from the list.

1. Find the required dataset.
2. Click the dataset.
3. Select Insert into query.

The dataset name will be added to the query editor.