budibase
budibase copied to clipboard
BB Table Rows Filter on Static Formula - all operators disappeared in version 2.23.12
It seems there was a (unwanted?) change in table rows filter... I have a column set as a static formula, it was ok in previous versions as I could use any operator for filtering (in my case a Like operator). But in version 2.23.12 there are no more operators presented in the Builder...
Tried to revert :
- Reverted to version 2.22.19 in App Builder (Self Hosted BD configuration). No Effect...
- Did change the composer yaml to force BB using 2.22.19 image Status: Downloaded newer image for budibase.docker.scarf.sh/budibase/apps:2.22.19 No Effect...
Solved (with still the 2.22.19 version) when I changed the table, by adding (duplication) another column (duplication of a static formula column). Maybe an issue with the table schema?
Steps that SHOULD reproduce the issue: A/ Setup a 2.22.19 version B/ Create table with two numbers column, and a static formula such as -{{ Col1 }}-{{ Col2 }}- C/ Create screen with a DataProvider on this table D/ Add a filter on the static formula using Like operator E/ Upgrade to version 2.23 F/ Check if filter is ok in the DataProvider
I did try to update (again) to 2.23, and I have the issue again. But this time, even adding or duplicating columns have no effect and the operators are still blanked. Trying to revert to 2.22 and cross fingers... :-(
A simple revert to 2.22 from the App Builder did not work (operators still blank). I had to change the docker-compose.yaml to refer to version 2.22.19, then stop the docker instance (docker compose down). Then restarted budi with the CLI. And then operators are back...
I'm also seeing this in the cloud version:
The PR for this has been linked in the issue. A new release just needs to be made. Once thats done this should be fixed with the newest/latest release. 2.24.2
The PR for this has been linked in the issue. A new release just needs to be made. Once thats done this should be fixed with the newest/latest release. 2.24.2
Sorry - I wasn't sure if there cloud and OS versions followed the same codebase so thought I better tag it in.