Skip to main content
F
FR_101619751-Visitor
1-Visitor
September 9, 2022
Question

ThingWorx 8.4.5- Adding/Deleting grid rows within mashup

  • September 9, 2022
  • 2 replies
  • 2610 views

I have a mashup with an advanced grid that displays data coming from sql server database. I want to be able to add and remove rows in order to add or delete row data. I was able to add two two advanced grids. Grid one showed all my data and grid two was empty. I was only able to select multiple rows by holding ctrl button. That's the only way I could pass data to the other advanced grid. Is there another way of doing this? I want a user within the mashup to be able to add/delete rows.

2 replies

Rocko
Rocko19-Tanzanite
19-Tanzanite
September 12, 2022

Multi-selecting rows using CTRL is the standard way of multi-selecting, why would you want another way?

It is unclear, what the real question is.

Also, please note that your version of Thingworx is out of support for almost a year. You might want to use a current version.

M
M4RC14-Alexandrite
14-Alexandrite
September 13, 2022

Hello,

 

you can use the "List Shuttle Widget" to select items from an existing list, the source, and place them on a new list, the target. 

c.f. https://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/ListShuttleWidgetThemable.html

However, you can move an element to the destination list only once. Otherwise you have to create a workaround with 2 grids.

 

Best regards

Marc

F
FR_101619751-VisitorAuthor
1-Visitor
September 13, 2022

Hello,

 

There doesn't seem to be a List Shuttle Widget in the version of ThingWorx I am using(8.4.5).

But this widget would seem to resolve the issue of selecting from a source and placing on a new list (the target).

Is there something like the "List Shuttle Widget" in this version I am using?

 

Thanks

M
M4RC14-Alexandrite
14-Alexandrite
September 20, 2022

Hello,

 

if the shuttle list widget really doesn't exist I recommend you a workaround.

You need a grid which shows the "available data" (I call it Source-List). Then you need another grid, for the target data (I call it Target-List). Behind the Target-List there can be a DataTable (e.g. with User-Name as PrimaryKey), where the selected rows are stored. Then you add some buttons that either add the selected row from the source list to the target list or delete the selected row from the target list (DataTable).

 

In this workaround you can add parts of the source list several times to the target list. If you want a row to be available only once, you have to extend the functionality a little bit.

 

Best regards

Marc

Terms & ConditionsCookie settingsAccessibility statement