Yes/No field Filter not working

  • 1 October 2018
  • 2 replies
  • 61 views

I have an object with some date fields and some text fields and one yes/no field (boolean)

However I am finding impossible to filter that field.
I want to ommit the record where that field is true, but no filtering related to that boolean field is working whatsoever.
Some of the things I have tried are,

  • booleanField Not Equals True
  • booleanField Less than 1
  • booleanField Equals True (at this point I just wanted to see if it was working)
  • booleanField Equals False

No filtering works. Does K2 not filter boolean fields?

Am I doing something wrong?

the last thing I found was related to a Sharepoint object not a K2 SmartObject and it was from 2008 which I doubt applies to K2 4.7 at this point with all the cummulative updates.


2 replies

Badge +9

I tested with SmartBox SmartObject on List View, and the filter seems to be working for me.   My environment is 4.7 with March CU.   Can you provide more details and screenshots of your issue?

I found out what the problem was. Apparently since the field was empty, it did not evaluate to either true or false. I would have thought an empty boolean field would evaluate to false but that's not the case. Now that I have populated a 0 in the SQL database it evaluates correctly. 
Thank you guys!!

Reply