Issue 425: Hard to figure out how to filter on true/false columns in Document Grid

Status:closed
Assigned To:Guest
Type:Defect
Area:Skyline
Priority:2
Milestone:3.2
Opened:2015-07-17 16:19 by Brendan MacLean
Changed:2018-10-16 14:18 by Brendan MacLean
Resolved:2018-10-15 15:26 by Nick Shulman
Resolution:Fixed
Closed:2018-10-16 14:18 by Brendan MacLean
2015-07-17 16:19 Brendan MacLean
Title»Hard to figure out how to filter on true/false columns in Document Grid
Assigned To»Nick Shulman
Type»Defect
Area»Skyline
Priority»2
Milestone»3.2
So hard, in fact, that I still haven't figured it out.

When I try to set a filter on a true/false column I get the following options:

Has Any Value
Equals
Does Not Equal
Is Blank
Is Not Blank

Which of these actually pertain to a true/false column?
Has Any Value? I get everything.
Equals true/True/TRUE? I get nothing.
Does Not Equal true/True/TRUE? I get everything.
Is Blank? I get nothing.
Is Not Blank? I get everything.

Maybe the choices should be simply:

Is True
Is False

Sure would be clearer to me. Can you give me a workaround trick that allows me to actually differentiate True and False with the current filtering options?

2018-10-15 15:26 Nick Shulman
resolve as Fixed
Statusopen»resolved
Assigned ToNick Shulman»Brendan MacLean
Equals True
Equals False
Does Not Equal True
Does Not Equal False
all work now.

Also, if you try to do something else like:
Equals Yes
then you get the error message "String was not recognized as a valid Boolean".

All of those filter options ("Is Blank", etc) do pertain to a boolean column, since all boolean columns in the Document Grid can theoretically be blank if the parent object (e.g. "Peptide Result") for the row does not exist.

2018-10-16 14:18 Brendan MacLean
close
Statusresolved»closed
Assigned ToBrendan MacLean»Guest