Search multiple field on one line

[Ernst]

Has anybody done or can help with multiple fields on one line. We are looking for something similar to using the three search lines with and AND,but for speed of use just want to type it all on the first line.

So in the demo for example going to inventory search, and putting "red shirt" in the description will give you all the red shirts. The same as putting red on the first line, and then shirt on the second line.

The Like statement allows us to do red%shirt but this would only work if the first word came first.

Apparently the old Clear system did this nicely, so we would like to match it.

Cheers,

[Mike.Sheen]

Hi Ernst,

To make this clear, you want to be able to type into a search field in a Jiwa search dialog the following:

Red shirt

And it to return results where the field contains the text Red AND shirt?

Mike

[Ernst]

Hi Mike,

Yip thats exactly it, We would like to just put in a string of words on the first line, like a google search, and see all the words with AND between them.
Is there a way to change the way the search finds things.

Can think of a number of clients who would find this really usefull.

Thx,

[Ernst]

Hi Mike,
Any update on if this will be possible?
Thx,

[Mike.Sheen]

Hi Mike,
Any update on if this will be possible?
Thx,

Sorry, Ernst - haven't had a chance. I'll spend a few minutes on it once 7.1 is released.

Mike

[Ernst]

Brilliant Thanks

[Scott.Pearce]

I had a quick look at this. It appears to me that it's not possible. *Maybe* via some ugly string manipulation. To that end, I'm going to add some events into the various search functions that will allow a plugin to more easily and robustly hook in and manipulate behaviour. These events will of course be in 7.1 and later.

[perry]

Hi Scott,

Do you think using full text search on SQL would work?

select * from vIN_Main_Search
where contains(Description,'"parts*" OR "computer*" )

I would create an index view (avoid changing standard table definitions), then fulltext catalog on the description field.

[Ernst]

Description would have to be full text indexed. To use that.
If we could split the search box into 3 using the space between the search words, and have 3 AND Like %Text%, that would work.

But how do we modify the where clause from our plugin?

[Ernst]

Hi Mike/ Scott,

Now that 7.01 is out, any more thought on this one.

Was looking at viewtopic.php?f=26&t=504&p=1699&hilit=search#p1699

And wondering if it is possible to get the entered field, and build our own "Where" clause.

Thanks,