Class: UU::DataTable::DataTable

Examples:

# Assume that we have DataTable with six columns
dtt.data.number_of_columns # 6

# Value [3,5,0] means that only fourth, sixth and first column will be displayed in that order
column_list = [3,5,0]

# Value [1] means that only second column will be displayed
column_list = [1]

# Value [5,4,3,2,1,0] means that six columns will be displayed in reverse order
column_list = [5,4,3,2,1,0]

# get column list options
column_list = dtt.column_list # [3,5,0,1,4,2]

# same as above
options = dtt.options
column_list = options[:columnList]

Examples:

# sort ascending by fourth column
column_sort = [3]

# same as above but we filter columns that only third and second column is displayed
# so we sort by fourth invisible column
column_list = [2,1]
column_sort = [{:column => 3}]

# sort by second column ascending, than first column descending, than third column ascending
column_sort = [1, {:column => 0, :desc => true}, 2]

# get column sort options
column_sort = dtt.column_sort # [{:column => 1}, {:column => 0, :desc => true}]

# same as above
options = dtt.options
column_sort = options[:columnSort]

Examples:

# get column types options
column_types = dtt.column_types # [{:column => 1, :type => "ues-button", :label => "OK", :tooltipType => "custom", :tooltipText => "Confirm"}]

# same as above
options = dtt.options
column_types = options[:columnTypes]

Examples:

# get selected rows, number 3 means that fourth row was selected
data = dtt.data # DataTableModel object

# get number of rows
data.number_of_rows # 13

# remove seventh row
data.remove_row(6)

# add column with label 'Surname'
data.add_column("Surname")

# add new row at the end
row = [ "Andrew", 13 , "1415-07-06T19:20+01:00", "ues:TERR[123]:ATR[12345]" ]
data.add_row(row)

# set column type to 'datetime' at last column
data.set_column_type(-1, UU::DataTable::DataTableModel::ColumnType::DATE_TIME)

# set empty DataTableModel object
dtt.data = UU::DataTable::DataTableModel.new()

Examples:

# the last two rows will have same style as header row 
footer_row = {:size =>  2}

# text in last row will be bold  
footer_row = {:size =>  1, :styleClass => "bold"}

# get footer row options
footer_row = dtt.footer_row # {:size => 1, :styleClass => "financialCell1"}

# same as above
options = dtt.options
footer_row = options[:footerRow]

Examples:

# show header row
head_row = true

# hide header row
head_row = false

# get head row options
head_row = dtt.head_row # false

# same as above
options = dtt.options
head_row = options[:headRow]

Examples:

# get options
options = dtt.options # Hash

# output:

   {
     :page => true,
     :startPage => 0,
     :pageSize => 20,
     :columnList => [3,5,0,1,4,2],
     :columnTypes =>[{:column => 0,
                      :styleClass => "bold italic",
                      :textColor => "#FF0000"},
                    {:column => 1,
                      :type => "ues-button",
                      :label => "OK",
                      :tooltipType => "custom",
                      :tooltipText => "Confirm",
                      :width => 150},
                    {:column => 3,
                      :type => "ues-link",
                      :icon => "false",
                      :newWindow => "true"},
                    {:column => 5,
                      :type => "date",
                      :styleClass => "headCell",
                      :dateFormat => "dd.MM.yyyy HH=>mm"}
                   ],
     :columnSort => [{:column => 1}, {:column => 0, :desc => true}],
     :columnFilter => [{:column => 1, :value => "P"}],
     :styleClass =>"portal yellow",
     :headRow => false,
     :footerRow => {:size => 1, :styleClass => "financialCell1"}
   }

# get pageSize option
page_size = options[:pageSize] # 20

# get columnFilter options
column_filter = options[:columnFilter] # [{:column => 1, :value => "P"}]

Examples:

# turn paging on
 page = true

# turn paging off
 page = false

# get page options
page = dtt.page # true

# same as above
options = dtt.options
page = options[:page]

Examples:

# Assume that we have DataTable with 100 rows
dtt.data.number_of_rows # 100

# we get 20 pages each with 5 rows
page_size = 5

# we get 10 pages each with 10 rows
page_size = 10

# get page size
page_size = dtt.page_size # 20

# same as above
options = dtt.options
page_size = options[:pageSize]

Examples:

# Assume that we have DataTable with 10 pages
dtt.data.number_of_rows # 100
dtt.page_size # 10

# second page is start page
start_page = 1 

# last page (tenth) is start page
start_page = 999

# get Start page options
start_page = dtt.start_page # 1

# same as above
options = dtt.options
start_page = options[:startPage]

Examples:

# set style to red portal table
style_class = "portal red"

# set style to high priority portal table
style_class = "portal priorityHighest"

# set style to green frame table
style_class = "frame green"

# set style to violet gradient table
style_class = "gradient violet"

# get style class options
style_class = dtt.style_class # "portal yellow"

# same as above
options = dtt.options
style_class = options[:styleClass]