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

http://www.google.com

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