Filters "Is empty" on Number column bugs the table

[mikesealey]

Checklist

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

Hosting

• Self
  • Method: Docker
  • Budibase Version: 2.29.23

Describe the bug Experiencing an issue when filtering the response from a REST API where the column type is Number, and the filter is looking for "is empty", and any of the rows are Null

This ticket has been raised following a Community Support discussion on Discord

To Reproduce Steps to reproduce the behaviour:

1. Make a REST API query that returns row(s) containing a Null value in a number column
2. Add a Data Provider set to get the results of that Query
3. Add a Table set to show the results of that Data Provider 4a. Add a filter to the table [Numerical Column containing Null] is not empty 4b. Add a filter to the table [Numerical Column containing Null] is empty

Expected behavior Filter should fetch rows where [Numerical Column containing Null] is not empty and display the table

Screenshots Column type manually changed to Number in schema before being passed to table in order to build this example app

App Export REST API filters bug-export-1721823758124.tar.gz

Desktop (please complete the following information):

• OS: macOS
• Browser Chrome
• Version 126.0.6478.127 (Official Build) (arm64)

Additional context Add any other context about the problem here.

[linear[bot]]

BUDI-8489 Filters "Is empty" on Number column bugs the table