Page Comparison

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 to Data Source tab on the grid configuration page and go to Data Source tab 
   Image Removedpage 
   Image Added
   
   
2. Select previously created data source from the drop down
   Image Removed
   
3. Result Preview will display information from the selected data source
   Image Removed
4. Configure Mapping: 
   Image Added
   
   

5. Specify SQL query or JSONPath depending on the data source type

   REST data source	SQL data source
   Image Added	Image Added

   
   

6. 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 Image Added	Tip Example of the data retrieved from the Jira Server database. Image Added

   
   

7. 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.

   Image Removed

   
   

   REST data source	SQL data source
   Image Added	Image Added

   
   

8. Save changes.
   This is how it looks on the issue view.
   Image Removed
   
   

Congratulations! Now you know how to initialize grid with an external data source.

Check the video below to see how it works.

...