Is it possible to add extra parameters to a postgrest url? I’m trying to use embedded filters simila...

# supabase-kt

[blakelee]

Is it possible to add extra parameters to a postgrest url? I’m trying to use embedded filters similar to how this article is using them in JS. The foreign key mapping works, but because I can’t add extra parameters I can’t do extra filtering

A query like this works

supabaseClient.from("my_table")
  .select(Columns.raw("id, other_table(*)")

but if I want to add a parameter in the url like other_table.some_field=is.not.null then I can’t do that

[Jan]

I'm not sure I understand what you want to achieve. So you want to filter by a foreign key?

[Blake Oliveira]

Yeah it's essentially a filter, but the way the embedded filters work doesn't use a filter=... parameter. Instead it would be table.field=is.not.null

I managed to get it working in a curl

[Jan]

🤔 There is no filter parameter. All filter work like you described. This should work:

supabaseClient.from("my_table")
  .select(Columns.raw("id, other_table(*)") {
    filter {
        //normally the `isExact` method would work, but since we are negating we have to call this method:
        filterNot("other_table.field", FilterOperator.IS, null)
    }
}

[Blake Oliveira]

Sweet, that did work. Thank you