Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

6 posts by 3 authors in: Forums > CMS Builder
Last Post: April 18, 2018

I have been working through transferring a static site to CMSB. As I add the records from the static site I am adding the most recent first.

However this poses an interesting dilemma. Once I am finished, the records are in the reverse order of what I eventually want. I have over two hundred records that dragging and sorting each one is extremely time consuming.

What would be nice to have is several mechanisms to control how dragsortorder can be used.

  1. A checkbox in the section editor that can toggle whether new records are added to the top or bottom of the list.
  2. An advanced command that allows you to sort selected records either ascending or descending.
  3. A modified 'create record here' plugin that can add records below or above the current selection.

There has been a number of issues with dragsortorder mentioned in the forum and I believe some thought into the above would solve many of them.

------------
Jeff Shields

Hi Jeff,

With Drag Sort Order default sorting, you can change that under the section editor Sorting tab to be either:

dragSortOrder DESC - to have new records appear at the top of the record list (default)
or
dragSortOrder ASC - to have new records appear at the bottom of the record list

Also, you can use the Create Record Here plugin, which you mentioned, to add records exactly where you want. Here is the link for anyone else interested in this plugin:
https://www.interactivetools.com/add-ons/create-record-here/

And if you have a group of records that have a common value you could search on, you could drag from within the search results. 

---------------------------------------------------
Cheers,
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Hey Jeff, 

We don't have an automatic feature for that yet.  But would a MySQL query that would reverse the sort order of the existing records help? 

Dave Edis - Senior Developer
interactivetools.com

That is all I need for now.

------------
Jeff Shields

Hi Jeff, 

Backup the table first through the CMS, then try this: 

UPDATE cms_yourtable SET dragSortOrder = 1000000 - dragSortOrder

Replace cms_ with your table prefix and yourtable with your table name.

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com