[ic] Trouble with coordinated search to test for inactive

[Mike Heins]

Quoting Stefan Hornburg (Racke) (racke at linuxia.de):
> On Tue, 6 Apr 2004 20:57:45 -0700
> "Ron Phipps" <rphipps at reliant-solutions.com> wrote:
> 
> > Hello,
> > 
> > I have the following fields in my products table:
> > 
> > sku
> > title
> > short_description
> > long_description
> > import_inactive
> > user_inactive
> > 
> > A user would like to search by keyword for the value 'test'.  I would
> > like to show all products where import_inactive = 0 and user_inactive =
> > 0 and either sku, title, short_description or long_description contain
> > "test".  I've tried several different search strings, but have yet to
> > come up with one which satisfies all of these requirements.  Any ideas?
> 
> co=1
> sf=import_inactive
> se=0
> op===
> sf=user_inactive
> se=0
> op===

Yes....

> lf=sku
> ls=%test
> lf=title
> ls=%test

Or:

sf=:long_description,short_description,title,sku
se=test

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

There's nothing sweeter than life nor more precious than time.
-- Barney