Submitted by Tom on 2013/02/05 09:11
 
Site is slow as molasses in January today -
it keeps timing out so I'm unable to search.
 
I want to filter a text field (the Item field) for text Abc AND (text Def OR text Ghi)
Result would be items like
Abc Def
Abc Ghi
Abc Def Ghi
 
Filtering for Abc works fine with
Item like "*Abc*"
 
I've tried
Item like "*Abc*" AND ("*Def*" OR "*Ghi*")
Item like "*Abc*" AND (item like "*Def*" OR "*Ghi*")
 
I've tried one in the source and the other in filter (I'm filtering all items)
 
Whenever and wherever I add the OR bit - it causes all the Abc items to disappear.
 
 
I'll add it to the help page if I can figure it out with your help,
thanks! tom
 
 

Comments

 
Site has woken up a bit but it's not easy to search for AND & OR...
 
I can filter for Abc Def  or Abc Ghi -
this works:
Item like "Abc Def" OR (item like "Abc Ghi")
 
but
Item like "Abc Def" OR "Abc Ghi"
returns all items :-(
(any reason why that is - is it just ignoring the filter but not telling me?)
 

re Site: Yes, I know, the web server is having issues. I've contacted them numerous times...
 
re Filer: You we're too far. Try:
Item like "*Abc*" AND (item like "*Def*" OR item like "*Ghi*")
 
I'll make a small change to the fast search window to return the equivalent SQL string. You'll be able to paste it in the filter box. In the search grid, you'll enter Abc AND (Def OR Ghi). Simple isn't ?
 

Tom

2013/02/05 10:44

Permalink

thanks Pierre, that works great -
seems I had tried something similar as well, but had left out an asterisk..
 
[quote=Pierre_Admin]I'll make a small change to the fast search window to return the equivalent SQL string. You'll be able to paste it in the filter box. In the search grid, you'll enter Abc AND (Def OR Ghi). Simple isn't ?[/quote]
that sounds very nice

[quote=Tom]Site is slow as molasses in January today -
it keeps timing out so I'm unable to search. [/quote]
 
Check out my tip for searching IQ with Google - searching IQ site with google
 
d