This article shows how to initialize the table grid with an external data source.
...
In order to initialize a grid with an external data source you should do the following steps:
...
1. Navigate to Data Source tab on the grid configuration page
2. Select
...
a data source you've already connected from the drop-down
...
| Tip |
|---|
We've added Jira |
...
fields as a default option of the data source in the list. Now you don't need to connect |
...
your Jira database as a separate data source. It's |
...
connected by default. |
...
3. Specify SQL query or JSONPath depending on the data source type
| REST data source | SQL data source |
|---|---|
|
...
4. Execute the query to get the data preview
| REST data source | SQL data source | ||
|---|---|---|---|
|
5. Configure columns mapping
Select columns from the data source to load information into previously created grid columns.
| Info | ||
|---|---|---|
| ||
Following column types could not display data from the |
...
external data source: |
...
, sequence, userlist, and formula. In case you have these |
...
types of data in your data source, please map them into columns with string or text type. |
| REST data source | SQL data source |
|---|---|
|  |
6. Save changes
...
| Note | ||
|---|---|---|
| ||
In case the grid is populated with data from an external data source you need to re-save it from the issue view to index external data. |
Congratulations! Now you know how to initialize the grid with an external data source.
...