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

Grid widget, dynamic Datashape from Query service

  • January 29, 2019
  • 1 reply
  • 1501 views

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

Best answer by Ascherer17

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

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.

Terms & ConditionsAccessibility statement