Hello,
I love using baserow for an equipment database we’re creating but I’m having an issue filtering rows using the ‘search’ query through the API.
Using the ‘search’ query is simple when I am trying to filter a row that simply contains a number or a string. For example, having parameters like
{“search”: “Building 405”}
works perfectly if “Building 405” is in a simple text entry column. This makes sense because when a get request is made for a simple text column like this, the response is simply
“building”: “Building 405”
What I’m struggling with, however, is if “Building 405” is not a text column, but is instead a link to another table that contains the names of all of the buildings in the database. When a get request is made for a linked table column, a dictionary is returned with key/value pairs. Something like:
"building": [
{
"id": 0,
"value": "Building 405"
} ]
Does anyone have any ideas how you can search a database via API for all rows containing a value stored in a linked table like this?