When filter empty return all table rows is selected no rows are returned, happens when the multi select field value is used in filtering

[ConorWebb96]

Checklist

• [x] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 2.31.3
  • App Version: 2.31.3

Describe the bug When a multi-select form component is used as the value for a filter, no rows are returned when using the filtering option Return all table rows when the filters are empty.

This is likely due to it not seeing an empty array value, that is being passed as having no value?

To Reproduce Steps to reproduce the behavior:

1. Import app export (provided in the linear ticket as a comment)
2. Navigate to the home screen
3. See the table component is empty

Expected behavior All rows should appear when no values are present for any of the form fields used for filtering.

Screenshots

Removed the multi-select field filter and it works.

App Export in linear comment

[linear[bot]]

BUDI-8605 When filter empty return all table rows is selected no rows are returned, happens when the multi select field value is used in filtering

[aptkingston]

I think your hunch is correct - it's probably not considering an empty array as an "empty" value. Pretty sure it only accounts for nullish values or empty strings.