Comments (2)
This is not directly possible by calling both methods, as these methods overwrite each other. However, you can use a and
or or
statement to combine multiple filters on the same column (See logical-operators). I'm publishing a version 0.8.4-dev-1
containing a experimental DSL method for both:
supabaseClient.postgrest.from("user_books")
.select(columns = "finish_date", count = Count.EXACT) {
eq("user_id", "some_user_id")
eq("reading_status", "FINISHED")
and {
gte("finish_date", "2023-01-01T00:00:00Z")
lte("finish_date", "2023-12-31T23:59:59.999999999Z")
}
}
The build should be done in around ~20-30min, let me know if it works or if I broke something! (Edit: It's done now)
from supabase-kt.
Works great, thanks so much for getting on that so quickly!
from supabase-kt.
Related Issues (20)
- [Bug]: Getting data is not working on safari 16 or lower HOT 4
- [Question]: Google ID Token sign in not working HOT 9
- [Question]: How to build the sdk locally and test with my Kotlin Multiplatform app HOT 3
- [Bug]: Apple Auth is broken HOT 4
- [Bug]: Create User parameter is not working in signInWith(OTP)/signUpWith(OTP) HOT 1
- [Feature request]: Switch back to Ktor-Server for the GoTrue JVM HTTP-Callback implementation for OAuth
- [Feature request]: Abstract Logging to make internal changes easier
- [Question]: Does Supabase Postgrest-kt support embedding entire Kotlin data objects as foreign keys? HOT 13
- [Question]: supabase-kt and android java HOT 3
- UnknownRestException when using signInWith(OTP) { email = ... } HOT 1
- [Bug]: The app crashes when it performs a refresh token operation. HOT 6
- [Feature request]: Support Realtime throttling
- [Bug]: Limit and nested joins HOT 2
- [Bug]: Concurrent connect() to Realtime can lead to instabilities HOT 1
- [Question]: Google ID:GetCredentialResponse error returned from framework HOT 5
- [Bug]: Problem with loading data in the background. HOT 6
- [Bug]: Im getting an error when I try to install Storage in hilt. HOT 13
- [Bug]: Using multiple order modifiers doesn't work properly HOT 2
- Unable to send or receive data after resubscribing to channel HOT 8
- [Feature request]: Add `signInAnonymously` method
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from supabase-kt.