topic Search Integer Field in Alfresco Archive

Search Integer Field

bgl — Thu, 18 Sep 2008 08:34:22 GMT

Hi,I have a property of an aspect that is an integer. I then want to search contents like "all contents that have this field larger than 10".Is is supported out of the box or do I have to customize Alfresco ? (any hint for doing this are welcome if not supported :wink: )thank youBoris

Re: Search Integer Field

bgl — Thu, 18 Sep 2008 11:36:56 GMT

Part of answer : integer indexing is supported (they are encoded in a special way in lucene index - see org.alfresco.repo.search.impl.lucene.analysis.NumericEncoder -).

But it seems that there are no way -out of the box- to use some shortcuts like field > 5 (that could be translated in the back end as a range query for lucene).

Re: Search Integer Field

andy — Mon, 22 Sep 2008 14:19:59 GMT

Hi

This is supported in the CMIS SQL 92 query language.
It is not part of the lucene query parser.

However, we have added open ended ranges in the form

@cm:woof[10 TO MAX]
@cm:woof[MIN TO 10]

MAX can be anything that does not parse to a number.

Andy