Join the Webstudio community

Updated 3 months ago

Baserow: ERROR_VIEW_FILTER_TYPE_UNSUPPORTED_FIELD

At a glance

The community member encountered an error when using a formula-based slug in Webstudio, which was not compatible with the "equal" filter type. The solution was to change the filter type from "equal" to "has_value_equal" in the API request. The community member explained that a single line text field in Webstudio is of type "string", while a formula field is of type "array", which caused the incompatibility. The community member provided the original and corrected API requests to help others who may encounter the same issue.

Useful resources
[βœ… solved]
I got stuck last week trying to figure out why a standard slug (single line text) from Baserow just worked fine in Webstudio, while doing a slug (formula) gave me this error.
ERROR_VIEW_FILTER_TYPE_UNSUPPORTED_FIELD
The filter equal is not compatible with field type formula

Formulas are much easier to deal with in the long run.

Long story short, a single line text in Webstudio is type string, while formula in Webstudio is type array. And then in this resource url that has equal, needs to be changed to has_value_equal.

Original that gave me error
Plain Text
https://api.baserow.io/api/database/rows/table/387xxx/?user_field_names=false&filters={"filter_type":"AND","filters":[{"type":"equal","field":"2941xxx","value":"amazing-slug"}],"groups":[]}


Change to:
Plain Text
https://api.baserow.io/api/database/rows/table/387xxx/?user_field_names=false&filters={"filter_type":"AND","filters":[{"type":"has_value_equal","field":"2941xxx","value":"amazing-slug"}],"groups":[]}


Hope this might help someone later on searching this discord for this error 😁
Attachment
69c3bb6feca7ac2011b15b89bde3f35a07de62dd_2_690x290.png
Add a reply
Sign up and join the conversation on Discord