[Yanel-dev] Search requirements

[Bruno von Rotz]

here's an example done in pseudo SQL:

Select * where
  "prince of persia" IN FULLTEXT
  and METADATA1 < "2010/06/01"
  and ( METADATA2 equals "Switzerland",
       or METADATA2 equals "Germany"
       or METADATA2 equals "Austria" )

Is this understandable.

Bruno

Michael Wechner schrieb:
> Michael Wechner wrote:
>> Bruno von Rotz wrote:
>>> While doing the implementation of a new website we have encountered 
>>> some use cases that are not optimally supported by the "on board" 
>>> search of Yanel.
>>> Here an example:
>>> Metadata1: Date, e.g. 2001/01/01 or 2010/06/02
>>> Metadata2: Countries, e.g. France, Germany, UK, Australia, Chile, 
>>> Switzerland, Austria
>>> Search example:
>>> Find all content that contains "Prince of Persia" and has 
>>> metadata1<2010/06/01 and metadata2 Switzerland, Germany or Austria.
>>>
>>> The current implementation allows either to search in the fulltext 
>>> with a query string or to search for one specific attribute, or to 
>>> scope down to a specific attribute.
>>> Any combination is not really supported.
>>>
>>> The ideal would be that either some type of SQL syntax 
>>
>> maybe we could re-use
>>
>> http://code.google.com/p/lucene-sql/
>
> also see JCR query object model
>
> http://www.day.com/maven/jdiff-jcr1-jcr2/jcr-2.0/javax/jcr/query/qom/package-summary.html 
>
>
> Cheers
>
> Michi
>>
>>
>> Cheers
>>
>> Michi
>>> or XQuery syntax is supported and allows to address specific 
>>> attribute/metadata and fulltext.
>>>
>>> My 5 cents.
>>>
>>> Bruno
>>>
>>
>


-- 
______________________________
Bruno von Rotz
WYONA
Hardstrasse 219 
CH-8005 Zürich 
Switzerland 
P: +41 44 272 91 61 
F: +41 44 272 91 62 
skype: wyona-switzerland
email: bruno.vonrotz at wyona.com
www.wyona.com