Home > Forum > Known bugs > Filter function in the report for calculated columns (using substring) no longer works after update to version 2021.1.4.36

Filter function in the report for calculated columns (using substring) no longer works after update to version 2021.1.4.36

22.09.2021
23:50
Nancy Herzog

We get an error message by using filter function in the report for calculated columns (using substring).

I use the following formula. SUBSTRING(WFD_AttText8,1,2). The report view shows the correct values in the calulated column.

As soon as I want to filter this column, I get an error message.


Does anyone else have the problem or am I doing something wrong?

Best regards
Nancy

Reply  
23.09.2021
01:56
MVP
Markus Jenni

We created a support ticket as it made the appearance that there was a change in the filtering behavior.

In our case we had quite a large list, which would return way more than one hundred distinct values. In our findings we have seen, that whilst entering the filter value, no more queries are being submitted.
In previous versions with every letter entered, a new query is being submitted.

Maybe your case is related to our problem.

Reply  
Solution (0) Helpful (0) Wrong answer (0)
Menu
Babinskiego 69
30-393 Krakow, Poland
office@webcon.com
+48 12 443 13 90