Select - Numeric Vectors: Search

The Search template appears in template list when a numeric vector field, that is a field with an ordered set of multiple numbers, of x2 (two numbers), x3 (three numbers), or x4 (four numbers), numeric vector type has been picked in the Select pane.  The template selects based on numeric vector values compared to the given value.

 

Search

Select by making comparisons against the desired extraction from the numeric vector  field specified in the Use parameter, using the given Condition,  compared to the given value or values,  which can be values from a field, a specified value, or the result of an expression that evaluates to a numeric value or to a datetime value depending on the data type of the extraction specified in the Use parameter.

 

Use options:

 

  • value 0 - Use the first component of the vector.
  • value 1 - Appears with x2, x3 and x4 types.  Use the second component of the vector.
  • value 2 - Appears with x3 and x4 types.  Use the third component of the vector.
  • value 3 - Appears with x4 types.  Use the fourth component of the vector.
  • vector -  Use the vector value in the source field.  

 

 

Condition options:

 

  • between - Select records with values between the At least and At most values, inclusive.
  • equal (=) - Select records with values equal to the given value.
  • greater (>) - Select records with values greater than the given value.
  • greater or equal (>=) - Select records with values greater than or equal to the given value.
  • less (<) - Select records with values less than the given value.
  • less or equal (<=) - Select records with values less than or equal to the given value.
  • not equal (<>) - Select records with values not equal to the given value.

 

If we would like to select records that are NOT variations of the above, for example not between, select on the basis of one of the above and press Ctrl-I or Edit - Select Inverse to invert the selection.   Selecting using between and then pressing Ctrl-I is the equivalent of "not between" the given values.

 

The Round box allows automatic rounding of the source field number before comparing to the specified value:

 

  • none -  No rounding.
  • down (floor) - Round down to the next lowest Round to position value. 400.7 would round down to 400.   -400.7 would round down to -401 (which is a smaller amount, and thus "down," from 400).
  • to nearest (round) - Round up or down to the nearest Round to position value. When rounding to 1, a value of 400.5 or greater fraction will get rounded up to 401 while fractional parts less than .5 will get rounded down to 400.
  • to zero (trunc) - Rounding towards zero: Equivalent to rounding down for positive numbers, and rounding up for negative numbers.
  • up (ceil) - Round up to the next highest Round to position value. 400.2 would round up to 401.   -400.2 would round up to -400 (which is a large amount, and thus "up," from 400).

 

 

Launch the template by choosing a numeric vector field in the Select pane and then double-clicking the Search template.  When the template launches we can specify options.

 

 

Search : value 0

Use the first component of the vector.

 

Search : value 1

Appears with x2, x3 and x4 types.  Use the second component of the vector.

 

Search : value 2

Appears with x3 and x4 types.  Use the third component of the vector.

 

Search : value 3

Appears with x4 types.  Use the fourth component of the vector.

Search : vector

Use the vector value in the source field.

 

Notes

Numeric vector types - Numeric vectors are fields that have ordered sets of multiple numbers, of x2 type float32x2, float64x2, int8x2, int16x2, int32x2, int64x2uint8x2, uint16x2, uint32x2, uint6x2, of x3 type float32x3, float64x3, int8x3, int16x3, int32x3, int64x3uint8x3, uint16x3, uint32x3, uint6x3, or of x4 type float32x4, float64x4, int8x4, int16x4, int32x4, int64x4uint8x4, uint16x4, uint32x4, uint6x4.

 

See Also

Select - Numeric Vectors

 

Select - Numeric Vectors: Expression

 

Select - Numeric Vectors: Null

 

Select Reference

 

Select - Expression