Hi !
I succesfuly managed to query rows from my table using your python documentation (which is great, thanks)
Now, I’m trying to filter these rows using the filter__{field}__{filter} params key. It works on single ligne type fields but I did not succed with the link-to-table type. Does it require a different syntax ?
This is the code I used, the Client field is a link-to-table type:
So as you already probably figured, the syntax for the param is filter_<name-of-the-field>_<name-of-the-filter> and in this case you are trying to filter over Clients with an equal filter. Clients is a link to table field and the reason why it doesn’t work is because link to table fields don’t have an equal filter.
The options you have are:
link_row_has
link_row_has_not
link_row_contains
link_row_not_contains
empty
not_empty
If you are ever unsure what types of filters your field supports you can look at the API documentation (REST API documentation // Baserow) under <your-database-name> → fields you can see a list of available filters for each field that you have in that database:
Just had a talk to the other devs, it looks like this isn’t part of what user_field_names is supposed to do. At the moment this flags only influences the response, so all the field ids are swapped by their names in the response. This does not mean that you can use the names in the filters as well instead of the ids if you set the flag.
I am curious to understand why this worked for you on the text field? It shouldn’t have, are you sure you used the name? Could you maybe provide a public url that does exactly that and it works?
@Nicolas
Great! What I meant is, I don’t think you can ever filter in the url using user field names, regardless of what field type, this just doesn’t work in general.