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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

How to Display Infotable Properties Vertically

Gurudev
3-Newcomer

How to Display Infotable Properties Vertically

I m trying to display the data coming from property of base type infotable on mashup vertically. Vertically in the sense all the Headers should occupy first column and the values corresponding to it should occupy subsequent columns.

Tried with creating a service to transpose the data, it didn't work out. 

 

It would be Great and Thankful if somebody helps me with an example code with which i can understand and implement it in my project as well.

 

Please find attachment for required format.

 

Thanks in advance.

 

 

4 REPLIES 4

You can look for a widget called Property Display widget in 8.4

Capture.PNG1.PNG

Gurudev
3-Newcomer
(To:zyuan1)

Thanks for the suggestion zyuan1

Tried using the Property Display Widget also but its displaying only 2 column grid of field name and value pairs. i wanted to design a grid with a 13 columns(a field name with 12 value pairs).

 

Thanks

I only know charts can do that, changing from X-Y axis to Y-X axis,  all the Grids don't have that function.

Maybe you need to change the infotable from m*n to n*m with custom service? 

There isn't any widget to do that OOTB actually.

 

Said that, you can kind of use Grid Widget with Show all columns to true and transpose the infotable (ensuring the first column of the transposed infotable has the column name), this should more or less work, it won't be super nice ( you can't get rid of column headers on Grid Widget).

 

Another option for nicer result, will be to use a Repeater Widget inside a Repeater Widget, but this solution will be complicated and also it's not recommended for performance and future ThingWorx Versions.

Announcements


Top Tags