budibase icon indicating copy to clipboard operation
budibase copied to clipboard

BB Table Rows Filter on Static Formula - all operators disappeared in version 2.23.12

Open esellier opened this issue 10 months ago • 3 comments

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

image

esellier avatar Apr 25 '24 09:04 esellier

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... :-(

esellier avatar Apr 25 '24 09:04 esellier

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...

esellier avatar Apr 25 '24 09:04 esellier

I'm also seeing this in the cloud version: image

mrjcgoodwin avatar May 03 '24 14:05 mrjcgoodwin

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

ConorWebb96 avatar May 03 '24 14:05 ConorWebb96

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.

mrjcgoodwin avatar May 03 '24 14:05 mrjcgoodwin