Supported Datatype Values

Search in Corda 7.2 Documentation

The setTypedData, setTypedDBQuery, and setTypedResultSet methods each take dataType as a parameter. The table below lists the supported values for dataType.

dataType Description Graph Types
legacy Data series are in rows and data categories are in columns. This is a legacy PopChart data format. All
item-value Data is stored primarily in two columns: Column 1 contains item names, and column 2 contains values. Columns 3 and above are available for meta data related to drilldown and hover. Bar, pie, pareto, line, step, radar, heat-map
group-item-value Data is stored primarily in three columns: Column 1 contains group names, column 2 contains item names, and column 3 contains values. Columns 4 and above are available for meta data related to drilldown and hover text. Bar, stacked bar, pareto, line, step, radar, heat-map, line-bar combo, stacked line-bar combo
line-xyt Data is stored primarily in three columns: Column 1 contains line names, column 2 contains X values, and column 3 contains Y values. Columns 4 and higher are available for meta data related to drilldown and hover text. XY Line, XY Scatter, TimeY Line, TimeY Scatter
line-xytbubble Data is stored primarily in four columns: Column 1 contains line names, column 2 contains X values, column 3 contains Y values, and column 4 contains bubble values. Columns 5 and higher are available for meta data related to drilldown and hover text. XY Bubble, XY Combo, XY Combo Dual Y, TimeY Bubble, TimeY Combo, TimeY Combo Dual Y
stock-hl Data is stored primarily in three columns: Column 1 contains date and/or time, column 2 contains high values, and column 3 contains low values. Columns 4 and higher are available for meta data related to drilldown and hover text. Stock HighLow
stock-hlc Data is stored primarily in four columns: Column 1 contains date and/or time, column 2 contains high values, column 3 contains low values, and column 4 contains close values. Columns 5 and higher are available for meta data related to drilldown and hover text. Stock HLC
stock-hloc Data is stored primarily in five columns: Column 1 contains date and/or time, column 2 contains high values, column 3 contains low values, column 4 contains open values, and column 5 contains close values. Columns 6 and higher are available for meta data related to drilldown and hover text. Stock HLOC, Candlestick
boxplot Data is stored primarily in six columns: Column 1 contains item names, column 2 contains low values, column 3 contains Q1 values, column 4 contains median values, and column 5 contains Q3 values, and column 6 contains high values. Columns 7 and above are available for meta data related to drilldown and hover text. Box-plot
boxplot-outliers Data is stored primarily in six columns: Column 1 contains item names, column 2 contains low values, column 3 contains Q1 values, column 4 contains median values, and column 5 contains Q3 values, and column 6 contains high values. Columns 7 and higher contain outliers. Box-plot with Outliers

The following sections provide samples of well-formed data tables for each supported dataType value.

legacy

This parameter value forces typed methods to function as legacy untyped methods. For example, calling setTypedData with dataType = legacy is equivalent to calling setData.

item-value

When dataType = item-value, data tables should be organized as in the following example:

Item Value  Meta-data1 Meta-data2  Meta-data3
item 1 100 www.corda.com  myHoverText Other Text
item 2 200      
item 3 300      

group-item-value

When dataType = group-item-value, data tables should be organized as in the following example:

Group Item Value Meta-data1 Meta-data2 Meta-data3
group 1 item 1 100 www.corda.com  myHoverText Other Text
group 1 item 2 200      
group 1 item 3 300      
group 2 item 1 400      
group 2 item 2 500      
group 2 item 3 600      
group 3 item 1 700      
group 3 item 2 800      
group 3 item 3 900      

line-xyt

When dataType = line-xyt, data tables should be organized as in the following example:

Item x y Meta-data1 Meta-data2 Meta-data3
item 1 1 2 www.corda.com myHoverText Other Text
item 1 3 4      
item 1 5 6      
item 2 7 8      
item 2 9 10      
item 2 11 12      
item 3 13 14      
item 3 15 16      
item 3 17 18      

line-xytbubble

When dataType = line-xytbubble, data tables should be organized as in the following example:

Item x y bubble Meta-data1 Meta-data2 Meta-data3
item 1 1 2 3 www.corda.com myHoverText Other Text
item 1 4 5 6      
item 1 7 8 9      
item 2 10 11 12      
item 2 13 14 15      
item 2 16 17 18      
item 3 19 20 21      
item 3 22 23 24      
item 3 25 26 27      

stock-hl

When dataType = stock-hl, data tables should be organized as in the following example:

Item high low Meta-data1 Meta-data2 Meta-data3
item 1 3 2 www.corda.com myHoverText Other Text
item 2 9 7      
item 3 5 1      

stock-hlc

When dataType = stock-hlc, data tables should be organized as in the following example:

Item high low close Meta-data1 Meta-data2 Meta-data3
item 1 9 1 7 www.corda.com myHoverText Other Text
item 2 8 2 5      
item 3 7 3 5      

stock-hloc

When dataType = stock-hloc, data tables should be organized as in the following example:

Item high low open close Meta-data1 Meta-data2 Meta-data3
item 1 9 1 5 7 www.corda.com myHoverText Other Text
item 2 8 2 5 5      
item 3 7 3 7 5      

boxplot

When dataType = boxplot, data tables should be organized as in the following example:

Item low q1 median q3 high Meta-data1 Meta-data2 Meta-data3
item 1 1 2 3 4 5 www.corda.com myHoverText Other Text
item 2 2 3 4 5 6      
item 3 3 4 5 6 7      

boxplot-outliers

When dataType = boxplot-outliers, data tables should be organized as in the following example:

Item low q1 median q3 high outlier 1 outlier 2 Meta-data1 Meta-data2 Meta-data3
item 1 2 3 4 5 6 11   www.corda.com myHoverText Other Text
item 2 3 4 5 6 7          
item 3 4 5 6 7 8 1 14      

Labels:

released released Delete
Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.