Skip to main content
MichalC1-Visitor
1-Visitor
January 29, 2019
Solved

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

Ascherer17
Ascherer17Answer
16-Pearl
January 29, 2019

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.

View in thread

1 reply

Ascherer17
Ascherer1716-PearlAnswer
16-Pearl
January 29, 2019

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.

Translate
Terms & ConditionsAccessibility statement