[#CMP-404] Range searches use a lexicography range, does not suit for numbers and dates

Compass

Range searches use a lexicography range, does not suit for numbers and dates

Created: 17/May/07 03:52 AM Updated: 21/Jul/07 07:37 AM

Component/s:

Compass::Core

Affects Version/s:

None

Fix Version/s:

1.2 M3

Description

« Hide

The current fix is to query ranges this way :

birthday:[1870/01/01 TO 1920/01/01]
population:[00000001 TO 00000050]

However, it is not user-friendly.

It would be great to be able to search that way :

birthday:[01/01/1870 TO 01/01/1920]
population:[1 TO 50]

Forum thread : http://forums.opensymphony.com/thread.jspa?forumID=37&threadID=79744
Thanks

All

Comments

Change History

Sort Order:

[ Permlink | « Hide ]

Shay Banon added a comment - 21/Jul/07 07:34 AM

Latest version (1.2 M3 SNAPSHOT) supports range queries as described. With numbers, there no need to do anything and it should work (except for specifing the format. such as format="00000").

With dates, there is now an option to specify more than one date format in the format tag. For example: format="yyyy-MM-dd;dd-MM-yyyy". The first one will be the format stored in the index, the second one (and any others) are formats allowed in the query string (including the first one, of course).