Grid data clicks give meta data information

[LY_10691079]

Hi everyone,

I am using Thingworx 8.5 version I have a data in grid coming from database through sql services now what I am thinking is suppose on grid data if user click on any row there should be a pop which should be opening the meta data related to that data like suppose

we have student data in grid and column are like Name School, Address 

and each student have some meta data like ex: Ram when user hover over Ram it should be giving its meta meta data information  

 similary for each row having having meta data so can I do this in thingworx if yes then How 

please give me a detailed overview if it is possible in thingworx 

I am thinking of Child data Tree grid  advanced widget  but not sure how can I do that  If anyone have any please let me know 

Best Regards,

Lav.

[TonyZhang · Accepted solution]

Hi @LY_10691079,

You can use Navigation function to open a mashup in a popup. By binding the SelectedRowsChanged event of the service that bound with the Data of Grid Advanced widget to Navigation function to trigger a popup whenever user clicks/selects another row. And pass SelectedRow of the Grid Advanced widget to the target mashup parameter to display infomation in target mashup based on the Selected Row in the parent mashup.

See below Help Center for more information on Navigation function.

https://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/index.html#page/ThingWorx/Help/Mashup_Builder/Functions/Navigation.html

Some suggestions:

Firstly, above implementation can be tricky and complex and not sure whether it leads to good user experience. Why not simply add another column called metadata and display the info in Grid alongside with other info?

Secondly, ThingWorx 8.5 is old and not supported anymore, better upgrade your ThingWorx to latest 9.4 or 9.5.