cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Grid widget, dynamic Datashape from Query service

SOLVED
Regular Member

Grid widget, dynamic Datashape from Query service

Hello,

 

I have a SQL Query service where, see attached for sample SQL result set

 

Capture.JPG

 

The columns headers will change daily, how to make it dynamic?

 

Thanks

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Grid widget, dynamic Datashape from Query service

If you simply need to show all the data that comes from the query, you can feed it into the Grid widget and set 'ShowAllColumns' on the widget.  If you need to manipulate the data in the Grid or only show certain columns, you'll need something more complicated.

1 REPLY 1

Re: Grid widget, dynamic Datashape from Query service

If you simply need to show all the data that comes from the query, you can feed it into the Grid widget and set 'ShowAllColumns' on the widget.  If you need to manipulate the data in the Grid or only show certain columns, you'll need something more complicated.