searching on tick boxes

[beuten]

We have a tickbox for customers that want to receive a newsletter. In the advance search we added the tickbox and it works great if we want to find customers that want a newsletter (box is ticked), but it we want to see only customers that don't want a newsletter (unticked), we get all customers (ticked and unticked).

Is there a way to show only records where the tickbox has NOT been selected?


Thanks

[pblag]

Hi!

I think that you need small customization. But it should be developed for you.
Please let me know if you are interested, we can develop it for you.

[beuten]

I think that you need small customization. But it should be developed for you.
Please let me know if you are interested, we can develop it for you.

Thanks for your offer, but we use someone locally if the community cannot help us directly.
Anyone else have any ideas?

[Angel]

That's a good one. You'd need to run an SQL query or apply some type of modification to the search components.

[michaelest]

Here's a temporary solution (or maybe semi-permanent)...

Scenario:
You want to search on a TickBox - or Check Box - . You want to get results based on whether or not the record has one of the boxes checked or not. Problem is that if you leave the box unchecked, the search returns ALL records.

Temporary Solution:
1. Open up the SearchForm.html file in the /sugarCRM/modules/MODULENAME folder.
2. Find the HTML code that draws the checkbox. It will look something like this:

<input name='db_fieldname' class="checkbox" type="checkbox" tabindex='1' {DB_FIELDNAME}>

3. REMOVE the class modifier and CHANGE the type to "text", so that it resembles something like this:

<input name='db_fieldname'  type="text" tabindex='1' {DB_FIELDNAME}>

4. Upload the modified SearchForm.html to the appropriate directory on your server.
5. When you go to do your search, what was once a 'TickBox', or Check Box, is now a text area.
6. Enter the word 'off' to search for unchecked (or 'unTicked') records, enter the word 'on' to search for checked (or 'Ticked') records.

Note, I don't know if it's 'off' and 'on' for non-english versions of sugarCRM, so...
-If you export your data to a .csv file with a header row, you will see what words are used in your TickBox column.

Good luck.

[roblaus]

Hi,

looks like a pretty cool solution to me. The important thing is that you do not change anything in the db but just the display type of one field.
I usually create drop downs for such puposes but of course those are not standard fields as they are used in the program logic for e.g. opt-out.

Thanks!
rl