How can I use 'View' instead of filterByFormula

I am going to implement filtering on my webstudio project that consumes data hosted on the Bika. As Bika API does not support advanced filtering, I want to try to use view. I have many filter conditions (e.g., name field like search and other fields equality search …).

So my main questions are:

  1. If I have 100 filter cases, should I have 100 views for every case?
  2. When would it be possible to use new filtering functionality?

Thank you! Looking forward to hearing from you.

Hi @Klinti_Shema ,

Thanks for sharing your use case — here’s some clarification:

  1. Using View for filtering works well if your filter conditions are fixed. But if you have 100+ dynamic combinations (like searching by name, status, etc), then creating 100 views isn’t practical. In this case, we recommend holding off and waiting for the upcoming filter parameter feature.

  2. Dynamic filtering support via API is already on our roadmap for Q2 - the team is actively working on it, and we’re aiming for a release around April. You can see Kelvin’s reply here::point_right: Why doesn't the Get Records API Endpoint support the `filterByFormula` parameter? - #4 by Kelvin

We really appreciate your patience — and we’ll keep everyone updated as soon as it’s live!

Hi @Thea ,
Thank you for your reply. We are really looking forward to your update!

Any updates on this @Thea? Really need this!

Hi @Selven , thanks for following up! The dev team is still working on this — it’s not ready just yet, but any updates will be included in our weekly Release Notes: Bika.ai v1.0.4 Release Notes | Bika.ai

Really appreciate your patience! :raised_hands:

The guys are working hard, the notes are piling up! But this is just such a crucial aspect of databases :pray:

Hey @Thea is this still the plan to release the filtering parameter this month? :pleading_face::pray:

Hi @Selven — I just followed up on the progress, and it’s likely not launching in April as originally planned — the team’s currently tied up with a heavy task load. I totally understand how important this feature is for your workflow, and I’ll be following up on it just like you. Really appreciate your patience — we’ll make sure to update the Release Notes as soon as it’s ready!

Looks like I will need to go with Aitable for now. Any idea if the filter names will be the same? Asking for SEO purposes

Hey @Thea any hope for this month? :slight_smile: