The Movie Database Support
Support → API Support
Discovery sort result
posted by iblopSTAFFMOD on October 11, 2014 at 9:54 PM
Hi! After last update, I realise that my results using the "discovery" method got weird results Take a look:
http://api.themoviedb.org/3/discover/movie?api_key=XXXXX&vote_count.gte=10&sort_by=release_date.desc
{"adult":false,"backdrop_path":"/vkSD3JjyW7XKuK4z88mhPgqD2k1.jpg","id":229407,"original_title":"Puppy","release_date":"2013-12-10","poster_path":"/maBSw4YgUzjQoowiMI51FG0Npzc.jpg","popularity":0.36656922222498,"title":"Puppy","vote_average":8.4,"vote_count":24},
{"adult":false,"backdrop_path":"/uNa5sbuoVvXFIdVo0De2HJrrxOd.jpg","id":227156,"original_title":"The Giver","release_date":"2014-08-15","poster_path":"/pBId6jhii1vP2CShtrGLB3SuKhc.jpg","popularity":9.03227783839263,"title":"The Giver","vote_average":6.8,"vote_count":78}, ...
It is sorting the date release in a random way... Am I doing something wrong?
Reply by Travis Bell
on October 23, 2014 at 10:43 AM
@hosam: Can you take a look at the results now? We should be sorting by the first release date now.
@matt: Sorting by
original_title.descwould is sorting Z-A, so you would indeed see the foreign chars first. If you're looking for A-Z, that would beoriginal_title.asc. This is just sorting by the UTF-8 character bytes so things like punctuation have a lower code than numbers, which are lower than letters. See here.Cheers.
Reply by hosam
on October 23, 2014 at 10:53 AM
yup the results now are back to normal. I think it is even bit better. Thanks man!
Reply by Matt
on October 23, 2014 at 12:33 PM
I understand why it's sorting Unicode first because of the character codes being higher, but because the translated title is what's being displayed it looks out of order. I'm guessing the system is not capable of sorting by translated title? My app let's you sort by title, date, and rating when browsing a genre, and the title sort looks broken to users. I've been debating the best way to handle it, and taking into consideration what users in other countries would see. I apologize for all of the questions - I am not the original author of this app, but it was turned over to me because the author didn't have time to update to the new API version. Not having ever seen the responses from the old version, I have no idea whether I'm seeing new behavior or not.
Reply by Travis Bell
on October 23, 2014 at 12:54 PM
We only just added sorting by title, so it's a brand new feature that didn't exist until ~2 weeks ago.
Our search server is not able to sort by the translated title. There's no connection to a requested language and a result until it's further down the line, after the response has already been returned by search. We can only sort on static fields, hence it being original title.
Cheers.
Reply by Matt
on October 23, 2014 at 12:58 PM
Rats, that's what I thought. Thanks.
Reply by stermi
on October 26, 2016 at 6:30 AM
Hi guys, the Discover API is still broken. When you add the sorty_by=release_date all filters release_date.gte and release_date.lte are totally ignored. Here's my issue discussion: https://www.themoviedb.org/talk/58106900c3a3687477004f4f