Blocking Query Offset and Constant Combinations (Understanding Sun Master Index Configuration Options (Repository))

Understanding Sun Master Index Configuration Options (Repository)

Blocking Query Offset and Constant Combinations

You can use a combination of offset and constant values to define range searching for a field.Table 9 describes the query formed for combination offset and constant search scenarios.

The following variables are used in these tables:

field_name is the field name as defined in the search page section of the Enterprise Data Manager file (the field named field_name is used for exact searching)
value is the value entered into the exact search field
value_from is the value entered into the field_name From field
value_to is the value entered into the field_name To field
lower is the lower constant or offset value
upper is the upper constant or offset value

In Table 9, the field configuration in the Enterprise Data Manager file defines the field twice for searching, once with the choice attribute set to “exact” and once with it set to “range”.

In the following cases, when field_name is populated but not used in the WHERE clause, its value is used for weighting purposes. These cases are marked with an asterisk (*).

Table 9 Combination Constant and Offset Range Queries


Offset Configuration in the Candidate Select file	Fields on EDM	Fields Populated for Search	Query Result
upper offset and lower constant are defined	field_name field_name From field_name To	field_name	where field_name >= lower and field_name <= (value + upper)
upper offset and lower constant are defined	field_name field_name From field_name To	field_name From field_name To	where field_name >= value_from and field_name <= value_to
upper offset and lower constant are defined	field_name field_name From field_name To	field_name From	where field_name >= value_from
upper offset and lower constant are defined	field_name field_name From field_name To	field_name To	where field_name <= value_to and field_name >= lower
upper offset and lower constant are defined	field_name field_name From field_name To	field_name field_name From	where field_name <= (value + upper) and field_name >= value_from
upper offset and lower constant are defined	field_name field_name From field_name To	field_name field_name To	where field_name <= value_to and field_name >= lower
upper offset and lower constant are defined *	field_name field_name From field_name To	field_name field_name From field_name To	where field_name >= value_from and field_name <= value_to
upper constant and lower offset are defined	field_name field_name From field_name To	field_name	where field_name <= upper and field_name >= (value + lower)
upper constant and lower offset are defined	field_name field_name From field_name To	field_name From field_name To	where field_name >= value_from and field_name <= value_to
upper constant and lower offset are defined	field_name field_name From field_name To	field_name From	where field_name >= value_from and field_name <= upper
upper constant and lower offset are defined	field_name field_name From field_name To	field_name To	where field_name <= value_to
upper constant and lower offset are defined *	field_name field_name From field_name To	field_name field_name From	where field_name <= upper and field_name >= value_from
upper constant and lower offset are defined *	field_name field_name From field_name To	field_name field_name To	where field_name <= value_to and field_name >= (value + lower)
upper constant and lower offset are defined +	field_name field_name From field_name To	field_name field_name From field_name To	where field_name >= value_from and field_name <= value_to