Serach for Attribut within a SET with Multivalue Entry

Thomas Heusser

Hallo

we have some Document with a SET of Multivalues, e.g.

SET: Range

therein Multivalue Rows with the 2 Attributs Start and Stop

So we have Documents valid for Range 10...20 AND 50...60 which ends in 2 Rows in the SET:

Start:10 Stop: 20
Start 50 Stop: 60

We need now to Search, if a Document is in a given Range, e.g.:

Search for 12: Document should be in the result, because it's in the first range 10...20
Serach für 55: Document should be in the result, because it's in the second range 50...60
Search for 40: Document should NOT be in the result, because it's nor in the first range 10...20 nor in the second range 50...60

How to do that?

By using something like “Attr_XXXXXXX_1: < 12” and “Attr_XXXXXXX_2: > 12” i get also results for 40, so it looks like ContentServer searches for "one of the first Multivalue Attibut" < x < "one of the second Multivalue Attribut" and does not search "within the same row"

Thomas

Steve Brezina

Hi Thomas,

Please read this post in another forum search of regarding category set attributes. 

As for effective range queries, you are probably interested in the qlrange LQL keyword.  i.e. "Attr_x_y": qlrange "100 ~ 1000".  You'll get best results if your region is typed as an integer the LLFieldDefinitions.txt file. 

I've included some help text on qlrange here:

QLRANGE

Description

The QLRANGE keyword finds Content Server items that contain words in the lexicographic or numeric range between two specified query expressions. The terms that you use to specify the range are also included in the range. If the specified terms are integers or real numbers, Content Server uses numeric ordering. Otherwise, it uses lexicographic ordering.

You must enclose the range in double quotation marks, " ", and separate the terms that you use to specify the range with a tilde, ~.

Syntax

QLRANGE < "expression >~ <expression">

Example

Type QLRANGE "giraffe ~ gnu" to find Content Server items that contain at least one word in the lexicographic range from giraffe to gnu, such as giraffe, giraffes, give, glow, gnome, or gnu.

Type QLRANGE "20000801 ~ 20000901" to find items that contain at least one number between 20000801 and 20000901, for example, dates between August 1, 2000, and September 1, 2000, inclusive.

Regards,

   Steve