The Movie Database Support
Support → API Support
Issue with discover date queries
posted by aceofpackSTAFFMOD on January 18, 2015 at 4:43 AM
Hello,
Just been testing some date filtering methods using:
Results returned were as followed (Notice Big Hero 6 release date is 7th November 2014, whereas the date query is asking between 2 dates in 2015):
{"page":1,"results":[{"adult":false,"backdrop_path":null,"id":302960,"original_title":"Scooby-Doo! Moon Monster Madness","release_date":"2015-02-17","poster_path":"/Mx9dBrZaVJlFmdebfao08FO6Z.jpg","popularity":0.148931664691812,"title":"Scooby-Doo! Moon Monster Madness","video":false,"vote_average":0.0,"vote_count":0},{"adult":false,"backdrop_path":null,"id":296918,"original_title":"Aoki Hagane no Arpeggio: Ars Nova DC","release_date":"2015-01-31","poster_path":"/6zotTztsrSGe9r7Rf2Xt6DpXwvS.jpg","popularity":0.177791037433986,"title":"Arpeggio of Blue Steel: Ars Nova Movie 1","video":false,"vote_average":0.0,"vote_count":0},{"adult":false,"backdrop_path":"/9kD98x8gX8NbkmATKjHE41lAvRe.jpg","id":297556,"original_title":"Justice League: Throne of Atlantis","release_date":"2015-01-27","poster_path":"/d4a9L9tW26JIgxJvbd5ok6xkNqV.jpg","popularity":2.671217003726,"title":"Justice League: Throne of Atlantis","video":false,"vote_average":7.5,"vote_count":3},{"adult":false,"backdrop_path":"/yFAvLoOl4313nkV9wuOyTTq9bJ.jpg","id":302429,"original_title":"Strange Magic","release_date":"2015-01-23","poster_path":"/c7LqBTRJIuZb7bz1w02to4Ydx4d.jpg","popularity":0.815184341251919,"title":"Strange Magic","video":false,"vote_average":0.0,"vote_count":0},{"adult":false,"backdrop_path":null,"id":316068,"original_title":"Madea's Tough Love","release_date":"2015-01-20","poster_path":"/AoYB91t9Gf8IHhSyACTD8okygMJ.jpg","popularity":1.33619612095987,"title":"Madea's Tough Love","video":false,"vote_average":0.0,"vote_count":0},{"adult":false,"backdrop_path":"/1WNayre36yQ2ZBNXzXksQotoK25.jpg","id":228165,"original_title":"The SpongeBob Movie: Sponge Out of Water","release_date":"2015-02-06","poster_path":"/1Rl8x6aZOEAAFYjOa97PBJ2RmFb.jpg","popularity":0.635657291511883,"title":"The SpongeBob Movie: Sponge Out of Water","video":false,"vote_average":4.9,"vote_count":5},{"adult":false,"backdrop_path":"/2BXd0t9JdVqCp9sKf6kzMkr7QjB.jpg","id":177572,"original_title":"Big Hero 6","release_date":"2014-11-07","poster_path":"/3zQvuSAUdC3mrx9vnSEpkFX0968.jpg","popularity":20.830350390602,"title":"Big Hero 6","video":false,"vote_average":8.4,"vote_count":316},{"adult":false,"backdrop_path":null,"id":292795,"original_title":"Gus","release_date":"2014-10-11","poster_path":"/c3syOAjhFvUG9xhZOHS8gcfxUaI.jpg","popularity":0.0648673899214548,"title":"Yellowbird","video":false,"vote_average":0.0,"vote_count":0},{"adult":false,"backdrop_path":"/lVshZpxU5EB8zXJrnXxblaDps6m.jpg","id":228326,"original_title":"The Book of Life","release_date":"2014-10-17","poster_path":"/fhq87M6NNXqYH4OUoIfsM6oDUA3.jpg","popularity":5.31146288347545,"title":"The Book of Life","video":false,"vote_average":7.7,"vote_count":76}],"total_pages":1,"total_results":9}
What could be the reason for this? Is there a second date being included too?
Cheers, David
Reply by Travis Bell
on January 18, 2015 at 12:20 PM
Hi aceofpack,
Filtering by
release_date.gteandrelease_date.ltefilters by looking at every single release date added to a movie. In Big Hero 6's case, you can see that there are a number of countries that have it being release in 2015.You might find it more useful to filter on
primary_release_date.gteandprimary_release_date.lteinstead. This will only look at the date marked as primary.Cheers.
Reply by aceofpack
on January 18, 2015 at 12:22 PM
Ahh! Brilliant thanks for the clarification.