CQRange (open)

Returns a query record that will match results in which a field values lies between the specified range

Syntax

LOADLIB "mod::consilio/lib/api.whlib";

RECORD FUNCTION CQRange(STRING field, VARIANT lowerterm, BOOLEAN includelower, VARIANT upperterm, BOOLEAN includeupper, RECORD options)

Parameters

STRING field

Field name

VARIANT lowerterm

Lower range value

BOOLEAN includelower

Whether to include exact matches of the lower range value

VARIANT upperterm

Upper range value

BOOLEAN includeupper

Whether to include exact matches of the upper range value

RECORD options

Options

FLOAT boost

Factor to increase or decrease the score for this query (defaults to 1f)

Return value

RECORD

Consilio query record