FR: Search API/ Summary page: search by date (or number?) range

[ebruchez]

This only applies for fields that are numeric or dates.

This depends on #966 "Overhaul persistence layers for relational databases", which introduces better and faster indexing and will make this RFE much easier to implement.

Persistence API and implementations need to support range queries:

• we already have a parameter to specify the type of query, need to specify "range" and pass one or two values and the operation
• all persistence layer implementations need to be updated (eXist, relational)
• if needed, new tables and proper indexes need to be looked into

FR Summary page:

• for numeric and dates, structured search needs a new UI to enter ranges
• options, maybe with dropdown, see attached screenshot from iTunes for inspiration

[ebruchez]

+1 from evaluator

[ebruchez]

+1 from customer

[ebruchez]

We don't necessarily need to support this feature with eXist (see #4141).

[avernet]

I think this would require adding a orbeon_i_control_date table to have the dates available in a table, so we can then search on those dates, like we do a distinct values for #6014.