The Movie Database Support

Case Filter with: release_date_gte: 2020-01-01 release_date_lte: 2024-12-31 with_watch_provider: 8|9|10 sort_by: vote_count.desc

Expected: Only film in the range of date sorted with vote_count_desc

Effective Output: FIlm sorted with vote_count_desc before release_date_gte

It's my fault?

4 replies (on page 1 of 1)

Jump to last post

Hi @sourheart,

First off, the filters are release_date.gte and release_date.lte.

And if you're using these filters, you'll want to make sure to use a region filter as well, unless you're meaning to query all release dates worldwide. If that's not what you want, I would suggest switching to primary_release_date.gte and/or primary_release_date.lte.

But more importantly, I'll need to see the full HTTP request you're making before I can tell you anything for certain.

Hi @travisbell

This is the curl

curl --request GET \
     --url 'https://api.themoviedb.org/3/discover/movie?include_adult=false&include_video=false&language=en-US&page=1&release_date.gte=2021-01-01&release_date.lte=2023-12-31&sort_by=primary_release_date.asc&with_genres=27&with_watch_providers=8%7C9%7C10' \
     --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiJ9.eyJhdWQiOiJhMzg2MDE5ZTM0NDUwNGE5ZTAwMTg4Mzk3YWQ3OGNlMyIsInN1YiI6IjY1ZGM5YThhMDNiZjg0MDE4NGFmZTNmNCIsInNjb3BlcyI6WyJhcGlfcmVhZCJdLCJ2ZXJzaW9uIjoxfQ.XF71Pcl__4rX8xr5KMzug5gvhnDzuMq5HhxCX5YtbLU' \
     --header 'accept: application/json'

As you can see the first result is:

{
      "adult": false,
      "backdrop_path": "/tQRHrssevbysfmDG9FbA86qesCH.jpg",
      "genre_ids": [
        27,
        878,
        18
      ],
      "id": 3016,
      "original_language": "en",
      "original_title": "Dr. Jekyll and Mr. Hyde",
      "overview": "A doctor's research into the roots of evil turns him into a hideous depraved fiend.",
      "popularity": 7.498,
      "poster_path": "/u8OL0RbTNzqqB1WmkxroTBXohnv.jpg",
      "release_date": "1920-03-18",
      "title": "Dr. Jekyll and Mr. Hyde",
      "video": false,
      "vote_average": 6.769,
      "vote_count": 130
    }

Right, you have sort_by=primary_release_date.asc but are filtering by release_date.xxx. As I mentioned above, you should change that.

https://api.themoviedb.org/3/discover/movie?include_adult=false&include_video=false&language=en-US&page=1&primary_release_date.gte=2021-01-01&primary_release_date.lte=2023-12-31&sort_by=primary_release_date.asc&with_genres=27&with_watch_providers=8|9|10

Ok, perfect with this change it works, thanks!

A little feedback: I've seen a bit of the movie API for the "recommended" feature, it would be even more useful if you could also select the primary_release_date range there too

Can't find a movie or TV show? Login to create it.

Global

s focus the search bar
p open profile menu
esc close an open window
? open keyboard shortcut window

On media pages

b go back (or to parent when applicable)
e go to edit page

On TV season pages

(right arrow) go to next season
(left arrow) go to previous season

On TV episode pages

(right arrow) go to next episode
(left arrow) go to previous episode

On all image pages

a open add image window

On all edit pages

t open translation selector
ctrl+ s submit form

On discussion pages

n create new discussion
w toggle watching status
p toggle public/private
c toggle close/open
a open activity
r reply to discussion
l go to last reply
ctrl+ enter submit your message
(right arrow) next page
(left arrow) previous page

Settings

Want to rate or add this item to a list?

লগইন