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 |