Data Types
Summary
Section titled “Summary”Data types tell Rokks how a field can be sorted, filtered, aggregated, displayed, and used in alerts.
MOCKUPSource-derived illustration — not a captured product state
Fields / Parameters
Section titled “Fields / Parameters”| Type | Type | Description |
|---|---|---|
| Text | Field type | Names, categories, statuses, and labels. |
| Number | Field type | Measures that can be summed, averaged, ranked, or compared. |
| Timestamp | Field type | Dates and times used for timelines, ordering, and schedules. |
| Boolean | Field type | True or false flags. |
| Enum | Field type | Controlled sets of known values. |
| JSON-like value | Field type | Nested or semi-structured content that may need transformation before analysis. |
SQL preview responses preserve SQL NULL as JSON null. PostgreSQL non-finite
floating-point values use the strings "NaN", "Infinity", and
"-Infinity" because JSON numbers cannot represent them truthfully.
Example
Section titled “Example”Use a timestamp for order date, a number for revenue, and text or enum for order status.