Page Comparison

This article shows how to initialize the table grid with an external data source.

...

1. Navigate to Data Source tab on the grid configuration page 
   
   
   

2. Select previously created data source from the drop-down
   

   TipWe've added Jira database as a default option in the list. Now you don't need to connect you Jira database as a separate data source. It's already connected by default.v

   
   

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
   Tip Try the example REST data source with users' data https://jsonplaceholder.typicode.com/users	Tip Example of the data retrieved from the Jira Server database.

   
   

5. Configure columns mapping
   Select columns from the data source to load information into previously created grid columns. 

   Info
   title Note!
   Following column types could not display data from the extenral data source: date, date/time. sequence, userlist and formula. In case you have these type 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
   title JQL search limitation
   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.

   
   

...