Notice: CMSB v2.60 Beta 1 (Jan 30, 2014)

Hi. I would be interested in better understanding the new search feature defined as:
"OR searches in the CMS and all viewers, you can now show results that match ("one thing" OR "another"), not just exact matches"

I learn best by a code example, if that can be provided.

Thanks in advance.
~ Deborah

Hi Deborah, 

Sure, see our addons page here: http://www.interactivetools.com/add-ons/

I can show all the addons with the keyword "builder" like this: 
http://www.interactivetools.com/add-ons/?name_keyword=builder

And all the addons with the keyword "login' like this:
http://www.interactivetools.com/add-ons/?name_keyword=login

But if you wanted to show addons that contain "builder" or "login" this doesn't work: 
http://www.interactivetools.com/add-ons/?name_keyword=builder&name_keyword=login

Because PHP overwrites the first value with the second (it just shows plugins with "login" in the name).  To get around this you can put [] before the = and it tells PHP to store those values as a list (or array).  And we've added some code to detect that and turn it into an or search.

So now this works (you just need to add [] before the =

http://www.interactivetools.com/add-ons/?name_keyword[]=builder&name_keyword[]=login

You can safely add [] after any fieldname, even if you're just searching for one value.  Here it is in a search form: 

Keyword 1: <input type="text" name="name_keyword[]" value="" /><br/>
Keyword 2: <input type="text" name="name_keyword[]" value="" /><br/>

And you can also do multi-value <select>'s as well.

So anytime you submit a search form or URL with two fields of the same name, so long as there is [] after the fieldname it will do an OR search for all the submitted values.

Hope that makes sense.  Let me know any questions.

And probably the most common example would be a multiple value list field or multiple checkboxes.  

Here's some examples of those:

<form action="?" method="get">
  Show records from division(s):<br/>
  A <input type="checkbox" name="division_match[]" value="A">
  B <input type="checkbox" name="division_match[]" value="B">
  C <input type="checkbox" name="division_match[]" value="C">
  D <input type="checkbox" name="division_match[]" value="D">
  E <input type="checkbox" name="division_match[]" value="E"><br/><br/>
  
  Show members from countries (hold ctrl to select multiple):<br/>
  <select name="country_match[]" multiple="multiple" size="5">
  <option>Canada</option>
  <option>USA</option>
  <option>UK</option>
  </select><br/><br/>
  
  <input type="submit" />
</form>

HI Dave

here is a speed test run from our server using v2.60

Hi All, 

Thanks for your feedback.  I've released v2.60 final.  Here's the updated changelog items since the last beta.  

- Admin Backup: These log tables are now skipped during backup: _outgoing_mail, _cron_log (can be overridden with plugin filter backupDatabase_skippedTables)
- CMS Menus: Image preview thumbnails are now limited in height so extremely tall images don't make page too long
- CMS Menus: Dates on list pages now display in whatever format is specified under: Admin > General > Regional Settings
- Compatibility: Fixed PHP 5.5 warning: Deprecated: preg_replace(): The /e modifier is deprecated
- Images: Using new faster image resizing code by default
- Security: Disabled autocomplete on login username and password fields so sensitive data won't be remembered in browser
- Viewers: whereRecordNumberInUrl() now ignores Google AdWords auto-tagging values (gclid) when determining record numbers

You can download the latest version here: https://www.interactivetools.com/order/upgrade.php

Feel free to post any questions on a new thread, thanks!

Hi Beta Testers, 

We've released a patch for a potential security issue found in the 2.60 release.  If you're running 2.60 please follow the instructions here to upgrade to 2.61:
http://www.interactivetools.com/forum/forum-posts.php?postNum=2233257#post2233257

Please email me at dave@interactivetools.com if you have any questions or need any assistance (we're always happy to help).

Thanks!