Connection Object List
Connection Object List to the left of the query editor displays the information on the metadata of available objects from the target connection. It displays all the available objects or a list of fields from a selected object.
You can hide and display Connection Object List using the button at the bottom of the page (left side).
Connection Object List User Interface Elements
Connection Object List consists of the following elements:
Connection Object List Header
Connection object list header shows what is displayed in the connection object list — a list of all tables/objects in the connection or a list of the fields in a specific table. If you navigated to this table via a foreign key, the header also displays the name of the used foreign key column. When displaying table fields, connection object list header also contains two buttons:
— this button on the left side of the header allows navigating back to the previous table or to the list of all tables.
— this button on the right side of the header opens the breadcrumbs list, which lists all the tables, by relationships of which you have navigated to the current table, and the corresponding foreign key fields used for navigation, and the All Tables entry. You can click an entry in this list to navigate back to the corresponding table or to the list of all tables.
Type to Filter Box
This box allows you to quickly find a table or field in the list. For this, start typing the name of the desired table or field in the list. The list will display only the tables or fields having this string in their names.
Additionally, the Type to filter box contains the following buttons:
— this button allows sorting the list of table fields alphabetically. By default, table fields are not sorted. They are in the same order as in the data source. Clicking it switches sorting between ascending, descending, and unsorted state. This button is not displayed when the list of tables is displayed.
— this button allows refreshing metadata displayed in the list.
Object list under the type to filter box actually displays the connection tables or their fields. First, it displays the connection tables (and views for databases). Second, after you click a table, it displays the list of its fields.
When it displays the list of table fields, it displays icons to the right of foreign key fields. You can click this icon to navigate to the corresponding parent table. For more details about browsing tables by relations in the Connection Object List check How to Create Joins.
When Connection Object List displays the list of fields, it uses the following icons to show the field type:
— fields with string data
— fields with numeric data
— boolean fields
— datetime fields
— fields with binary data
— virtual fields displayed by Skyvia, such as Records count pseudo-field.