Section Editor Feature request - dragsort order

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

By kitsguru - April 16, 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

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
interactivetools.com

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
interactivetools.com