Using the REST API, is there a best method for sorting cards in a list by due date?
I imagine I'd need to pull the cards that are all of the lists that I want to sort, figure out their positions vs their new positions, and generate a set of card pos update actions for cards that need an update, and then send those to the server by card PUT call(s).
Wondering if there's a better way. Can't seem to find anything in the API documentation (such as a lists->sort command) or by duckduckgo or the community search.
@Billy_Stidham you can see the list sorting algorithm I use in Trellinator here:
The docs for it are here:
You can read more about Trellinator here:
If I read it right, it looks like you're indiscriminately updating all of the cards pos values to the index (+1) of the array they end up in after sorting them. So your pos become 1, 2, ..., N?
Do you know what happens when a value you update a card pos to conflicts with another card that has the same pos value? Or, if the pos value of all of the cards in a list are not far enough away from each-other? I found some comments online speculating that Trello may change the value you give it or do a complete re-balancing of all of the card pos values if it doesn't like it or doesn't like the proximity spread.
I decided to go with sorting my cards and then if the new sorted set differs from the current pos set, sequentially, I do a full pass over the cards in the direction of new sort sequence and send them one by one to the "bottom" of their current list. After the pass is complete, the cards should be in the correct order. This leaves the responsibility for calculating the actual pos value in the API. That seems to be working.
@Billy_Stidham If there were a conflict, it would be resolved as a result of the conflicting card having it's position set later on (because there can only be one card for each position in the array anyway).
Trello's internal representation of the position is different, they don't come back as integers, but you can set them as integers and it just seems to deal with it :)
Hello Community! My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events