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

a14m commented 4 years ago

[X] I have created my request on the Product Board before I submitted this issue
[X] 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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

@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 commented 3 years ago

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

ghost commented 3 years ago

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 commented 3 years ago

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

petertenhoor commented 3 years ago

+1

Enabling a sort setting for a content type which enables drag & drop sorting would be great.

matthewthomsonnz commented 3 years ago

+1 Googled "collection order strapi" and now I'm here and disappointed - very fundamental feature and should be high priority

AugustGSP commented 3 years ago

I currently use an order field in place of this feature, luckily my collection size is only 5 or so items. The method doesn't scale though, I couldn't imagine maintaining order fields for more than 20 items this way. This feature would be a nice addition.

developerajendra commented 3 years ago

+1 this is really important feature, please pick this on high priority

dneckel commented 3 years ago

+1 This feature would be very welcome. For some use cases it is enough to use repeatable components which support ordering but if you need a dynamic zone you are currently out of luck as they are not supported as fields on components. As said before the manual approach with order field does not scale at all.

TheRoadSouth commented 3 years ago

Exploring strapi and really liking it so far. But +1 for this feature.

jdortegar commented 3 years ago

+1 We need this in our app for sure

iezqrom commented 3 years ago

Yes, upvote!

lauriejim commented 3 years ago

This issue has been mentioned on Strapi Community. There might be relevant details there:

https://forum.strapi.io/t/re-organize-documents-inside-a-collection/541/2

globalsysgabriell commented 3 years ago

+1 Upvote 👍

cgonzalezsan commented 3 years ago

+1 this is a really important feature. Nowadays, most of the CMSs have some kind of sorting implemented.

The best would be to have the order on the relation itself, by drag and drop. My use case is having a product which has and belongs to multiple product categories. I need to sort these products on the product category level, meaning that products will have different sorting depending on the product category. The only workaround I can think of, is to create a new JSON field in the product category which has an array of product IDs sorted in the manual way that I like. This is very hard to maintain for the client and user-unfriendly