Ordering Content Type entries in the List view (preferably using drag and drop)

[a14m]

• I have created my request on the Product Board before I submitted this issue
• I have looked at all the other requests on the Product Board before I submitted this issue

Please describe your feature request:
It would be really beneficial if there was a way to retain the order (using order column for example) of a collection and be able to update it via drag-and-drop on the collection view.

There are many cases when we want to have a certain order of items (regardless of insert order/id/filter/sort options provided in the view), and to be able to retrieve the data using the predefined order later (as seen in the collection view for example)

Using drag and drop would help as it's really tedious to go to a huge collection and pump the order column of each item (for a CMS user) or run a query on the database (for CMS power user)

most common use case, ordering an employee list on a company website (or add a new employee at a specific position)

[Aurelsicoko]

Can you share screenshots of what you call the "Collection View"? And maybe describe a bit more your use case. I'm pretty sure there is another way than providing a way to order collection.

Ordering relational data in entry makes sense, reordering collection makes less sense to me. Maybe because I don't understand well the use case.

[a14m]

Hey @Aurelsicoko, by "Collection view", I mean the table view (of a content-type) -as attached in the screenshot-

So the use case is that we want to have a way to easily change the ordering of a list (list of employees, list of featured posts, etc etc, so that when we are using graphQL to query the data, we get the list ordered... and for the content people to be able to change the website structure without having to do a lot of manual work)

as you can see (in the screenshot attached), we use a position or order integer column but we have to manually go through the whole table/list to update each entry in case we needed to insert something in the middle or update the ordering...
it would be really good if there is something like a drag and drop to allow the ordering (with minimal effort for the content people) to work with...

Please let me know if I can do more help, I'm actually looking into implementing a new order data-type (basically an integer) on content-type builder to provide the functionality, as we really need this feature if we are to use Strapi in production (but I'll probably need more help with the implementation from the strapi team).

[gregorskii]

This is a necessary feature, Contentful has it. I do see the PR is only for the bookshelf, is that the super type of the database ORM? Meaning would this work for Mongo as well?

[gregorskii]

I think there was some comment on this that got deleted. What is needed to test this on a project? Is it a custom fork of strapi? How can I test it for mongo?

[lukemcd]

I think this request would be very helpful. Perhaps "sortable" could be an option when creating/editing a collection type. The sorting action in the list view would automatically generate the order number either into a reserved field name or a numeric field the user creates and associates with sorting.

[kjng]

Another vote for this feature. In the meantime, I am also using a column to sort the data to the order I want.

A reserved "list order" field/column in the database would work well.

[ahrherrera]

Upvote for this feature. It's really needed when we need to sort records from a content-type.

In my case I need this because I need to custom reorder my app Products

[qudo-code]

I thought I needed this but now I am not so sure. I just made an "Order" column in the CMS that is type Number and then the front end sorts on this property. If you want it to reflect the same order in the CMS, just click the column header and do a normal sort on column.

[MartinN3]

@qudo-lucas yes but consider this as written by @a14m above your reply.

as you can see (in the screenshot attached), we use a position or order integer column but we have to manually go through the whole table/list to update each entry in case we needed to insert something in the middle or update the ordering...

[xAgustin93]

How's this business going, do you know anything?

Upvote for this feature. My usecase is that when I go to configuration view and drag and drop components, I want it to reflect in my graphql query. Any updates on this ?

[mizvyt]

I am building a help centre where the order of articles specified by the content manager matters. I second this approach and I think it should be higher on the priority list :-)