predicate present or true with null checkbox

[kaluznyo]

Hi,

Before 1.4, i use check box with field_present or field_true. If the check box is not checked, no condition is add to request.

But since 1.4 if I use this, I get 'WHERE field != 1' when check box is not checked.

Seem to be related to this features #335.

What is the 'new' way to make this work again. No check -> ignore predicat.

[jonatack]

Before looking into this, here is a copy-paste of my reply to a similar issue recently. This is still working fine in Ransack 1.4 for me.

---

For handling boolean results in searches, I've found I usually need three states: true, false, and all (default).

In that case, assuming your checkbox field has a checked value of 1 and an unchecked value of 0, the following in a search_form_for works, using a not_eq predicate:

  <%= f.select :field_not_eq, [['True', 0], ['False', 1], ['All', 2]] %>

or

  <%= f.select :field_not_eq, [['Yes', 0], ['No', 1], ['All', 2]] %>

[WayTang]

@Eric-Guo

[jonatack]

If your unchecked value is '0', have you tried with field_not_false?

That should give you WHERE field != '0'.

[aselder]

@kaluznyo Don't know if you've seen this or not: http://stackoverflow.com/questions/27890997/ransack-return-records-with-boolean-attribute-both-true-and-false-with-checkbox

TL;DR include the include_hidden: false option

[aldosolis]

@kaluznyo I did the following:

f.check_box :field_true, {}, 1, nil

nil is the value when is not checked. Did you find a simpler way?