Different Yurbi Data Type Explained
Version: Yurbi v12
Role: Builder or higher
Permission: Builder access to the application
This table describes the most data-types used internally to Yurbi. These data types were configured to allow for custom post-processing of data before it is displayed in the client.
Datatype |
Description |
Example |
cha |
Character data type – values can be any text string and are sortable as text |
String of Words |
num |
Numeric data type – values are expected to be numeric and sortable as numbers |
4387 |
udt |
Unix Date-Time – The underlying data is stored as unix date time (number of seconds since 1970) The UDT data type tells Yurbi to convert this value to a date time display. This is sortable as a date |
4/2/2015 15:35 |
dat |
SQL Date Time – the underlying data is stored in SQL Date time. This is sortable as date |
4/2/2015 15:35 |
lnk and ddn and 800 |
This is an internal data type where the field is processed into a hyper link. ** This datatype is deprecated and should be replaced with Ad-hoc field builder feature when creating reports |
|
For |
This is when a formula is applied to the field used in the builder. Specifically if none of the base data types (cha, num, dat, udt) apply |
n/a |
dmy |
Unix date time display as date part only. This will convert a unix date time stamp into a date part only string that is sortable as a date |
4/2/2015 |
tda |
This will convert a numeric representation of seconds to a “days” value |
86400 = 1 |
thr |
This will convert a numeric representation of seconds to an hours value |
3600 = 1 |
tmi |
This will convert a numeric representation of seconds to minutes |
60 = 1 |
500 |
This field will take a unix date time and subtract it from current time to get duration in days |
0.56 |
501 |
This field will take a unix date time and subtract it from current date to get duration in hours |
87.26 |
502 |
This field will take a unix date time and subtract it from current date to get duration in minutes |
59.86 |
503 |
This field will take a unix date time and subtract it from current date to get duration in seconds |
78 |
504 |
This field will take a unix date time and subtract it from current date to get duration in D:H:M |
6 days:10 hrs:30 min |
dhm |
Convert duration in seconds to get duration in d:h:m |
6 days:10 hrs:30 min |
600 |
Display a UNIX date time field in time part only |
15:35 |
dpo |
This will take an underlying date time value and display it as date part only |
4/2/2015 |
cur |
This will take a numeric value and display it as currency |
$564.25 |
tmr |
This will display a time span in seconds as a Count Down Timer |
|
idt |
Use this data type when the underlying data source stores a date value without a time element |
4/2/2015 |