RPI supports a Tuple data type at database column attributes. A tuple is a sequence of elements with a specific structure. Here is an example of a tuple value, which might be stored in a database column attribute: ('SPAM',99,4.52,'2017-10-01')
When you drag in an attribute with the Tuple data type to create a standard selection rule criterion, the following criterion types are available:
-
Compare to Constant
-
Compare to Attribute
When building a Compare to Constant criterion, and specifying a tuple value, the Edit Tuple Values dialog is displayed:
Each tuple element is displayed in a numbered list, with a value displayed at each. Data type-specific controls (String, Integer, Decimal, Date) facilitate data entry at the same.
Tuples are also supported as elements within database column values with the following data types:
-
Tuple: nested Edit Tuple Values dialogs are used to set values at the same.
-
List
-
Map
Note that the following operators are not supported when building a tuple criterion at a Google BigQuery database: >, >=, <, <=.