Kinetic grid filters do not work for empty or zero values

Kinetic ERP
,
1

So, a customer pointed out to me that the grid filters in Kinetic mode do not work for empty values (empty strings), or even for integer columns with a zero value. Anyone noticed this?

If you try to set a filter on an integer column to have only value == 0, nothing is shown in the grid. Same if you configure the filter for < 1, nothing comes up. If you filter for < 2, only the rows with a value of 1 are shown, 0’s are excluded.

For a string, neither the “Is Empty” or “Is Null” filters are working.

The behavior is the same no matter which screen I try. I also tried with the new preview filters, same behavior.

I assume there is likely already a PRB for it, just wondering if anyone else seen this?

2

image
image500×319 10.4 KB

I’m not seeing this behavior. I am able to search on Is Null and Is Empty for strings, and both equal to 0 and less than 1 seem to work fine.

3

Which exact version are you on?

4

Cloud 2025.2.17

5

Ok I think i narrowed it down a bit… The issue appears only on columns from BAQs that would return a null value. For example if you do a left join and there is no matching record in the second table. In that case the BAQ returns a NULL value, and it’s left to the client framework to interpret that as a default value for the type (string == empty, int == 0, etc). I still need to test it more thoroughly but it appears the filters do not work for those…