How to update datashape dynamically for different services ?

Question

Hello Experts,
 
I have 3 SQL queries- services as follows, each of them returns separate infotable containing different number of columns (See attachments). I have configured a list widget to populate the list of these services and I want to execute selected service when selection is changed in list.
 
To achieve this I am trying to write a java script service, but I am facing a issue since each of above services has their specific datashape as per their result. Could anyone helpout me to write this service to dynamically update the datashape of this java script as per the services which are being called by it or selected by list widget
 
Just for info, I am quite new to JS, so expecting your reply accordingly.

Thanks;
GS

tmisner · Accepted Answer

Hello again, I have modified the attached XML so this should now import into your 8.4 system. Please let me know if you have any further issues.

tmisner · Answer

Hello GS,

I went ahead and created a small example for you that shows the dynamic capabilities of the Grid Widget. This ios attached to my post.

As you will see I created a backing service that handles each possible service selection from the End User. This will dynamically change the format of the Infotable returned which results in the contents of the Grid being changed.

Please import the dynamic_grid_entities.xml file prior to importing the Data Table data.

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.