Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
21.9k stars 1.51k forks source link

External SQL data source filtering operators aren't working in the design view for relationship fields. #14041

Closed ConorWebb96 closed 3 months ago

ConorWebb96 commented 3 months ago

Checklist

Hosting

Describe the bug Operators are missing from the design screen's filters, e.g. when filtering on a data provider/table and trying to filter on relationship related fields. The operators don't appear.

To Reproduce Steps to reproduce the behavior:

  1. Setup a external database with relationships
  2. Connect to it via Budibase
  3. Create the relationship between the 2 tables
  4. Create a design screen.
  5. Add a data provider/table
  6. Add a filter on a relationship field.
  7. Try and select an operator
  8. See no operators appear

Expected behavior Should be able to select an operator that you wish to use e.g. equals to then a binding or string.

Screenshots

Screenshot 2024-06-28 at 09 14 38

Additional context No console errors, the operators just don't seem to be populating.

Weirdly the filtering works within the data area, its just broken in the design screen.

linear[bot] commented 3 months ago

BUDI-8403 External SQL database operators aren't working in the design view.

ConorWebb96 commented 3 months ago

Closing fixed here.