getting and browsing the Connection schema

Browsing the Connection schema

In order to get data from an object in the Connection, you will need to browse the Connection schema.

To do so, click on the Connection on the left, and use the + icons to navigate the schema tree :

Selecting the database schema

(new in version 2020 R2)

Some Connection types can have multiple database schemas.
By default, objects from all schemas are listed.
If instead you want to restrict the list to objects from a specific database schema, you can select it from the Database Schemas list :

Searching for an object

When the database contains many objects (tables, views, stored procedures, etc…), you can filter the list by clicking the magnifying glass icon :

In the text box that pops up, write the text that is contained in the desired object names :

This will filter to display only the objects whose name contain the text (the search is case insensitive).
Click the cross button to clear the filter.

Showing the fields of an object

Clicking one last time the + icon will show the list of fields in that object :

Field Type icon

Next to each field is an icon showing the data type of that field :

• : string
• : number
• : date
• : boolean
  

Refreshing the Connection schema

If the Connection schema has changed since you started browsing (maybe a table was added or removed, etc…), you will need to refresh it manually.

To do so, click on the pen icon on the Connection on the left, and select “Refresh Schema” :

Code192 2020 All rights reserved