[ic] Calling all search gurus

[Mark Johnson]

I knew I had run into this situation before. Jon Jensen reminded me of
the solution :)

For multi-field searches of the same "spec", you prepend them with a
colon.

<input type=hidden name=mv_search_field
value=":field1:field2:field3:field4">
<input type=hidden name=mv_searchspec value="foo">
..
..

Obviously, the ":*" stuff is just a wildcard expansion of this to all
fields.

Give it a whirl.

Mark

Ed LaFrance wrote:
> 
> Hi all -
> 
> Using IC 4.6.5 with MySQL.  Need to do a form-based search, something like
> this:
> 
> mv_search_field="field1,field2,field3,field4"
> mv_searchspec="foo"
> 
> mv_search_field="field5"
> mv_searchspec="1"
> 
> I need to find all products which have /foo/ in any of the corresponding
> fields, AND do not have '1' in the other field.  I thought this would be a
> simple coordinated search:
> 
> <input type=hidden name=mv_searchtype value=db>
> <input type=hidden name=mv_coordinate value=yes>
> 
> <input type=hidden name=mv_search_field value="field1,field2,field3,field4">
> <input type=text name=mv_searchspec value="foo">
> <input type=hidden name=mv_column_op value=rm>
> <input type=hidden name=mv_numeric value=0>
> 
> <input type=hidden name=mv_search_field value="field5">
> <input type=hidden name=mv_searchspec value=1>
> <input type=hidden name=mv_column_op value="!=">
> <input type=hidden name=mv_numeric value=1>
> 
> ..but it does not work.  The problem is the multiple search fields in the
> first group - if I search just one field, it works fine - multiple fields
> completely break the search.  Somehow I need to tell IC that "foo" in
> field1 OR field2 OR ... etc. is acceptable for the first group - it appears
> to be applying 'AND' logic to the list of fields instead.
> 
> Perhaps this can be done with an SQL statement? But I would rather not rely
> on searching products.txt, I prefer to search the db directly.
> 
> Thanks in advance for any suggestions!
> 
> - Ed L.
> 
> ===============================================================
> New Media E.M.S.               Software Solutions for Business
> 463 Main St., Suite D          eCommerce | Consulting | Hosting
> Placerville, CA  95667         edl@newmediaems.com
> (530) 622-9421                 http://www.newmediaems.com
> (866) 519-4680 Toll-Free       (530) 622-9426 Fax
> ===============================================================
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users

-- 
Mark Johnson
Senior Systems Architect - Professional Services
Red Hat, Inc.
E-Business Solutions
markj@redhat.com
703-456-2912