We had a requirement to drag and drop within the same table. The table viewed services (red in the attachment) that were accessed across routes (black in the attachment). Users could build routes and services in any order then drag the routes and services to achieve the routing they wanted. When a route or service was created a CI for it was created in the CMDB and relationships added.
The table couldn't view the CMDB directly so a staging table was used. When the users viewed the table records were built in the staging table using the CMDB data to achieve the view in the attachment. When a user selected a row and dragged it to another row there was workflow to delete the CMDB relationships that were no longer required and build new ones. The records in the staging table were then deleted, new records built and the table refreshed. Although the processing was relatively complex the users didn't notice and significant delay. Maybe you could also look into using a staging table to remove any limitation on the number of drag and drops a user might do? Cheers Peter -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Janne Olsson Sent: 19 June 2014 15:05 To: [email protected] Subject: Re: Drag and drop to sort within a table Thanks Doug, In this case I really need to drag within the same table. Today we have a visible field (Implementation order) that we manually edit and use to sort the table. Takes some time if you wanna move around a lot of requests and get them in the right prio order. I have a solution for it and it is working ok. I will work with a hidden sort order field and have a gap between the request. The backdraw with it that the gap will decrease for every move and if a request is moved to many times the gap will be 0 in the end. Planning to use a nighly escalation to set the sortorder with a gap for all request. I think it will be an ok solution. I will try to tune it as much as I can. I welcome any more ideas regarding this! /Janne _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
