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.

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

Add "status" column in subscriptions stripe to where filter "status" works outside of attrs #317

Open
wallacedevsantos opened this issue Jul 31, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@wallacedevsantos
Copy link

I can't search for signatures with status all in the stripe wrapper's foreign table, by default the api only returns signatures with status "active", so we need to have the option to filter by status "all", the code says we can filter by id, costumer and status, but status is inside attrs and doesn't work in reality.

If we do a search on Supabase, it does not return subscriptions with a status other than "active":

select * from stripe.subscriptions where status = 'all';

returns the error:
ERROR: 42703: column "status" does not exist
LINE 1: select * from stripe.subscriptions where status = 'all' limit 100;
^
HINT: Perhaps you meant to reference the column "subscriptions.attrs".

@wallacedevsantos wallacedevsantos added the bug Something isn't working label Jul 31, 2024
@wallacedevsantos
Copy link
Author

If I try to search for the status within attrs it will not return any results, only if I pass an id or client along

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant