Section Editor Feature request - dragsort order

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

By Damon - April 17, 2018

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)
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:

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. 

Damon Edis -

Hire me! Save time by getting our experts to help with your project.

By kitsguru - April 17, 2018

Thanks Damon,

I knew all that, I am asking for a change as that does not solve my problem.

The create record here only places a new record in one place, above or below depending on the sort order, sometimes you want it to go the other side Of the current position. 

if you read through my request, I was trying to demonstrate a situation where I have entered 200 records newest to oldest while transferring data manually from a static site. This causes the dragsortorder value to be in the reverse of what I eventually need it to be.

What I was hoping for was a mechanism to reverse the dragsortorder value for all or a selected group of records.

I had spoken with Greg before Imposted my request, and he understood the dilemna.

Jeff Shields

By Dave - April 18, 2018

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

By kitsguru - April 18, 2018

That is all I need for now.

Jeff Shields

By Dave - April 18, 2018

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