Skip to main content
V
VaibhavShinde16-Pearl
16-Pearl
December 22, 2020
Question

Sequence the rows of a grid by drag and drop thingworx

  • December 22, 2020
  • 7 replies
  • 2330 views

Hi,

I am looking to sequence the rows by dragging the entire row to another place.  How to make it in thingworx?

 

Thank you

 

7 replies

O
odukiya16-Pearl
16-Pearl
December 22, 2020

Hello @VaibhavShinde 

 

Can you please help me with more details here ?. If possible some screenshots may help in understanding your query.

 

Thanks

Om Dukiya

V
VS_97601651-Visitor
1-Visitor
December 22, 2020

Hi, @odukiya 

Thanks for Reply, 

just i need to swap the rows in Grid. if i drag 1st row and dropped at 3rd so here interchange of row should happen.

 

thanks

O
odukiya16-Pearl
16-Pearl
December 22, 2020

Hello @VS_9760165 

 

I don't think this widget supports that OOTB

the unfortunate 'ugly' way is to take the 'edited table' or 'selected row(s)' feed that into the source service and return the data in the new order.

the advanced and much harder way would be to create a custom widget

 

Thanks

Om Dukiya

    A
    Ashritha15-Moonstone
    15-Moonstone
    December 24, 2020
    1. Create an extra column for grid data 
      1. fill the column with numbers in ascending order 
    2. Allow  multiple selection in grid
    3. Add a button in mashup 
    4. Write a service to exchange the numbers (extra column) of the selected row and sort based on number
      1. If the selected row is more than 2, show some error message
    5. Trigger the above service on button click
    6. Use Event router to bind the output of two different service as input to grid
    7. Since the grid/service is sorted based on numbers , row shift can be achieved 
    V
    VS_97601651-Visitor
    1-Visitor
    December 24, 2020

    Hi @Ashritha ,

    what You think is.. , its Lengthy process to get the output , i dont know if below statement works as per my requirement. Please Give Feedback on this...

    * Can i put HTML code while adding rows to Infotable ? so that i can get the Clickable  Link or button in Runtime Grid.

    See as below...

    result.AddRow({

         valueColumn: myNumberalue,

         htmlColumn: '<a href="http://google.com">' + myNumberValue + '</a>'

    });

     

    Thanks

     

    A
    Ashritha15-Moonstone
    15-Moonstone
    December 24, 2020

    Answer is yes. 

    Another option will be the double click event with hidden link / navigation widget

      Terms & ConditionsAccessibility statement