Sort and date filter doesn't work

The Movie Database 支持

sourheart
STAFFMOD
发布于 2024 年 03 月 18 日 6:27下午

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 回复（第 1 页，共 1 页）

Travis Bell 的回复

STAFFMOD

于 2024 年 03 月 18 日 6:33下午

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.

sourheart 的回复

STAFFMOD

于 2024 年 03 月 18 日 6:46下午

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
    }

Travis Bell 的回复

STAFFMOD

于 2024 年 03 月 18 日 6:56下午

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

sourheart 的回复

STAFFMOD

于 2024 年 03 月 18 日 7:04下午

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

参与此讨论的用户

分类

The Movie Database 支持