What query language is this?

  • #1
Stephen Tashi
Science Advisor
7,017
1,237

Main Question or Discussion Point

I'm trying to figure out how to use the search interface on publicnoticeads.com. In the "advanced" search screen the field "With at least one of these words" does not work correctly. It appears to require all the words you list.

For example if I set state to be NM, the county to be Dona Ana, the keyword to be "foreclosure" and the "With at least one of these words" to be "Idaho", I get some hits. However, if I put "Idaho Missouri" in that field, I get zero hits.

pubnoticesearch.jpg


That query gives the message:
You searched for: county:Dona|Ana|foreclosure+(Idaho|Missouri)
Is this the syntax of some query language? Is there a way to trick the interface into working properly?
 

Attachments

Answers and Replies

  • #2
rbelli1
Gold Member
920
339
That looks like a Boolean expression generated from the input form. It is doubtful you can access anything at that level. At least it indicates what it makes of the freeform inputs.

| = OR
+ = AND
() works to group expressions
: = ???

BoB
 
  • #3
8,244
5,062
Did you click the link that says " View Search Tutorial"?
 
  • #4
Stephen Tashi
Science Advisor
7,017
1,237
The advanced search tutorial says
-- 'With at least one of these words': This field can have multiple words and the search will find notices that have any one word, some of the words or all the words.
which is not how the interface appears to work.
 
  • #5
358
108
commas?
 
  • #6
Svein
Science Advisor
Insights Author
2,025
649
I am not surprised. Many websites have a stupid interface to their database queries - they just string all the search queries together (which means an implied "and") and send it to the database Of course you get a very small number of hits. The only thing worse is when stringing all the search queries together means an implied "or" (and you get a large amount of hits, making the query useless).

Most people are used to Google which has a very intelligent approach to search queries - people using Google do not mind getting 20 000 hits because what they are looking for is usually on the first page.
 

Related Threads on What query language is this?

  • Last Post
Replies
3
Views
2K
Replies
7
Views
47K
Replies
5
Views
1K
  • Last Post
Replies
1
Views
2K
  • Last Post
2
Replies
33
Views
3K
  • Last Post
Replies
2
Views
3K
  • Last Post
Replies
2
Views
8K
  • Last Post
Replies
22
Views
4K
  • Last Post
Replies
7
Views
3K
Top