How to show MS SQL Server table values in Record List ?

Hi Purp1852,
Create a view which returns the data from 3 tables in your database, and then use query database smart service to retrieve the data from view. Now create a CDT with the same number of columns then publish the CDT to data store, now you can use query entity to retrieve the data from particular entity.

For displaying the data in grid you need to use grid layout with a!forEach() function in your page.

Thanks,
Santosh.

Hi Purp1852,
Create a view which returns the data from 3 tables in your database, and then use query database smart service to retrieve the data from view. Now create a CDT with the same number of columns then publish the CDT to data store, now you can use query entity to retrieve the data from particular entity.

For displaying the data in grid you need to use grid layout with a!forEach() function in your page.

Thanks,
Santosh.

Hi santoshd378 this helped me. I created a view and then a query rule. Can you help me with showing all the data on dashboard or gridlayout. How can i achieve it ? What are the correct syntax i write to get the data.