A modern programming language that makes developers happier.

kotlinlang

Is it possible to add extra parameters to a postgrest url? I’m trying to use embedded filters similar to how <https://biku.hashnode.dev/supercharge-your-data-fetching-with-supabase-sdk-and-postgrest|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

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

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

:thinking_face: 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)
    }
}```