Hi, I've got a problem with realtime functionality...
# help
h
Hi, I've got a problem with realtime functionality. This command here works:
Copy code
.from('$tableName:id=eq.$currentId')
        .stream()
        .execute()
But if i want to do more complex queries like Array Contains, I get the initial value but i don't receive any realtime updates. These command for example do not work:
Copy code
.from('$tableName:id=eq.$documentId')
        .stream()
        .execute()
.from('$tableName?$arrayName=cs.{"$arrayValue"}')
        .stream()
        .execute()
I would be very glad for any help, as I would like to use the realtime feature also with queries like these.
g
I thought realtime only supported .eq... Looks like a few more have been added in the new release but still limited (from github supabase/walrus): realtime.equality_ops are a subset of postgrest ops. Specifically: create type realtime.equality_op as enum( 'eq', 'neq', 'lt', 'lte', 'gt', 'gte');
h
Okay, I understand. Is it intended to expand the list of realtime.equality_ops ? Thank you for your response
g
You would probably need to post on github as a request or question for the developers. I saw one request for .in which would be very useful.
h
Thank you