Multiple nested filter query AND, OR

[gjk]

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What are the exact steps to reproduce this issue?

I am currently transitioning from Airtable to Baserow and need assistance with converting my existing Airtable query into a format that works with the Baserow API.
In Airtable, I was using the following formula to filter data:
OR( AND({service_addon_price_index_attribute_name}='country', {service_addon_price_index_attribute_id}=1), AND({service_addon_price_index_attribute_name}='customer_size', {service_addon_price_index_attribute_id}=2), AND({service_addon_price_index_attribute_name}='rental_period', {service_addon_price_index_attribute_id}=3), AND({service_addon_price_index_attribute_name}='notice_period', {service_addon_price_index_attribute_id}=4), AND({service_addon_price_index_attribute_name}='trailer_category', {service_addon_price_index_attribute_id}=5) )
Now, I want to convert this logic into a filter structure for Baserow.
I can achieve this filtering in the Baserow UI (see image attached), but I’m struggling to construct this query for the API.

Attach screenshots, videos, or logs that demonstrate the issue.

[frederikdc]

You should be able to achieve this by creating 6 filter groups.

1. Create a new view without any filters
2. Add a new filter group
3. Add the two conditions to the group using AND
4. Create a new filter group, set the conditions between the 2 groups to OR
5. Add the two conditions to the new filter group
6. Repeat this 5 times
   
   

If I check your screenshot, I think you are pretty close, but just added a filter group inside a filter group because I see 3 nestings of Where