Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Implement "having()" mechanism #338

Closed
neilotoole opened this issue Nov 22, 2023 · 1 comment
Closed

Implement "having()" mechanism #338

neilotoole opened this issue Nov 22, 2023 · 1 comment
Assignees
@neilotoole
Labels
enhancement

Comments

@neilotoole
Copy link
Owner

Is your feature request related to a problem? Please describe.
While group_by is implemented, somehow having isn't, making group_by somewhat silly.

Describe the solution you'd like
Implement having() mechanism.

$ sq '.payment | .customer_id, sum(.amount) | group_by(.customer_id) | having(sum(.amount) > 100)'
@neilotoole neilotoole self-assigned this Nov 22, 2023
@neilotoole neilotoole mentioned this issue Nov 22, 2023
Merged
@neilotoole
Copy link
Owner Author

This is implemented in sq v0.46.0.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@neilotoole neilotoole

Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@neilotoole