I think Carl was looking for something similar, though, to the ADDT Ajax function that allows you to reorder the column arbitrarily, so each item has an up arrow and a down arrow beside it... you then move things where you like and then click save at the top. It then rewrites an "order weight" column and you can then sort query by that same order weight column.

While ADDT is a dying animal, that was one of the good things it had... I am going to try to port that functionality into a stand-alone extension that could work with data assist.

Did you have any luck coming up with a way to do this? I have a customer who wants control of the order of his records. Not just ascending and descending. This arrow "weight" column feature sounds perfect.

I did find a way to do this but it is not a "quick fix" so to speak... in other words you would have to manually add it to each results/list page. The way I had a working model was to use jquery's draggable sortable widget and add a save function to that which would rewrite the order weight column. I need to go purchase a jquery documentation book to see if I can write some sort of function and script where it could be quickly deployed.

The way to do it would be just to create an unordered list wrapped around the repeat region and the table overall... then put each row within a list but then style the list so they have no effect on look of the table. Then just set the jquery id correctly to handle the movement of the lists.

I will try to dig out the code I used when I did this... especially since I have another project I could use this on. I may even see if there is an improved way to do this (which is why I need to pick up that jquery development book) - cause I would like to just assign the jquery ui id straight to the table row (which should be ok in theory).

Good news! I have successfully created a way to make DataAssist's Search Results table sortable through JQUERY and with a little bit of hand coding, it's pretty easy to create the mechanism to save the new order.

Better yet, it allows you to just drag them into any order - so it is much faster than the ADDT way where you had to go one at a time by clicking the arrows.

I will post a tutorial probably tomorrow... I gotta get some rest after working on this one all day.

That's awesome. Can't wait.So this will allow two features then, if I understand correctly.

First, on the front end of the web site, this could be added has a interactive rearrange of the records by dragging them up and down? For example if someone wanted to compare two records and one was at the top and the other was at the bottom, they could drag that one up?

And secondly, (the solution I need the most at the moment), on the back-end within the CRUD interface, the records could be updated as having weight over the others, and then appear that way on the front end?

I was trying to figure out a column I could add to the table that would allow this manually. But I don't know how you could prevent duplicate numbers. So if there were 10 records with misc. numbers (not IDs) of 1,2,3... and you wanted number 5 at the top, you couldn't just change 5 to 1 because then you would have two number 1s. So I'm guessing this new method will update them down the line? Can't wait to find out.