Add support for search releases between two dates

[remyleone]

Describe the feature or problem you’d like to solve

I would like to have search options and filter on the release list command

Proposed solution

For instance if I want to search for all release published in 2023 I would do something like that:

gh --limit 100 --repo scaleway/scaleway-cli release list --search "published_at:2023-1-1...2023-12-31"

[williammartin]

Hey @remyleone thanks for creating this issue.

Unfortunately, the platform API doesn't support this natively. I've sent the team a message to see whether this has ever been on their radar.

In the meantime I suppose we could in theory support this client side during our pagination loop. One of the tricky things is that the GQL API doesn't seem to allow for ordering by publish date at all so supporting that (as opposed to created_at) seems a bit more challenging because we'd have to get all releases, order them, and then filter them rather than being able to stop the pagination at a defined moment.

How interested are you in published_at vs created_at?

[remyleone]

Hello and thanks for the quick answer 😊
Because we use automation, created_at and published_at are usually very close to one another. So I would guess the easiest to implement could work.

[williammartin]

I was thinking about this in light of #8632 going in and I realised that you can kinda do this right now with the built in --json and --jq flags. It may not be totally sufficient for your use case but I did want to let you know about it just in case. Here's a command that would return the names and dates of all releases in 2023 (assuming the limit is high enough):

gh release list -L 100 --json "name,createdAt" --jq '.[] | select(.createdAt | startswith("2023"))'

[williammartin]

Additionally as I was over on #8579 (comment) I noticed that another maintainer said that filtering client side might be hard. I'm not sure exactly what they expected to be hard and unfortunately they are no longer with the company but just wanted to call it out here in case anyone else ends up looking at it before I have time to investigate.