Searching for unchecked checkbox.

[mrmmm]

Hello,
I am having a strange issue. I created a custom field of type "Checkbox" and added it to the opportunities module. I also added the field to the "advanced search" layout. On the search layout the checkbox is represented by a drop down with three values "Yes", "No", and a blank line. If I select Yes, the search returns all the records where the checkbox is checked. However, if I select "No", the search returns ALL records (not just the ones that are unchecked).
Am I missing something???
(Sugar CE Version 5.1.0 (Build 4732) )

Thank you.

[crmbalah]

Hi
The check box value will be saved as 1 and 0. So you should be create search drop down like this

Value   display
0	No
1	Yes

And customize the search query. Then only you will get correct result

[mrmmm]

Thank you for your reply.
I did not create the actual Dropdown, it is created automatically I guess. I also went into studio and changed the 'checkbox_dom' from "1-Yes, 2-No" to "1-Yes, 0-No".
But I am still facing the same problem. Is there something else I need to change? How do I customize the search query?
On the side-note, is this normal behaviour (bug) ir am I doing something wrong?
Thank you.

[chrislynch8]

Hi,

This is interesting

I have create a custom checkbox for Accounts, I added it to teh advanced search and it appears as a checkbox, like (my items only) - so I check it to search for all Accounts that have it checked. but when it is unchecked it shows all Accounts.

I will be interested to see how this is resoved...

Rgds
Chris

[mrmmm]

If it appears as a checkbox in search, then I guess it sort of makes sense that when unchecked it would show all records (since there is no "middle" or "grayed out" state available for the checkbox).
I do have "Enhanced Search" installed, and I am guessing that is the reason I get the dropdown and not just a checkbox.
However, as I mentioned earlier, I edited the checkbox_dom to 0 and 1, instead of 1 and 2. However, I am still not able to search for records that do not have the checkbox checked only.
Anyone else has any ideas?

Thank you.

[roblaus]

There is a story behind as far as I know. In erlier days a checkbox was a checkbox - even on the search panel. That had indeed the side effect that one could search for positive values (checkbox checked) but not for negative ones (unchecked). At this time we recommended NOT to use checkboxes at all.

For the past couple of versions (I do not know from when) the checkboxes (even existing ones) were converted automatically to dropdowns in the search. Since that time a search for negative values (0 = No) was possible.

I just checked it with my live version and it works (positive and negative) for old, original fields (do not call) as well as for new, customized ones (e.g. address checked).

[mrmmm]

What version do you have? II am running (Suga CE Version 5.1.0 (Build 4732). I have the drop down in the search form, but when I try the search for "NO" I get all the records. Did you have to change anything to get the search to work?

Thank you.

[roblaus]

5.2d and no mods in this area

[kenshiro]

If it appears as a checkbox in search, then I guess it sort of makes sense that when unchecked it would show all records (since there is no "middle" or "grayed out" state available for the checkbox).
I do have "Enhanced Search" installed, and I am guessing that is the reason I get the dropdown and not just a checkbox.
However, as I mentioned earlier, I edited the checkbox_dom to 0 and 1, instead of 1 and 2. However, I am still not able to search for records that do not have the checkbox checked only.
Anyone else has any ideas?

Thank you.

Which Enhanced Search version are you running ?

[mrmmm]

2.2 demo
Thank you.