Scout/Concepts/Table

Scout

Wiki Home

Website

Download • Git

Community

Forums • Blog • Twitter • G+

Bugzilla

Bugzilla

A table is data structure that can be represented in a TablePage or a TableField.

• implements: ITable
• extends: AbstractTable

Description

Table can contains a set of structured data: the structure of the entity is defined by the columns. Each entity contained in the table is a row. At the intersection of a column and a row is a Cell. A Cell describes how the value is represented (displayed text, colors, style, icon...).

Example

Imagine that you want to have a table of persons that are structured as followed:

• Name (String)
• First name (String)
• Age (Integer)
• Date of birth (Date)

A such table needs to contains 4 columns :

• NameColumn a String Column
• FirstNameColumn a String Column
• AgeColumn a Integer Column
• BirthDateColumn a Date Column

Here is how this table looks like in the Explorer View of the SDK:

Access to the data

To access a value of a table, the common pattern is to go through the column. For example if you want to access the age of a person, at a precise row index r, the code is:

  private Integer getAgeOfPersonAtRow(int r){
    return getTable().getAgeColumn().getValue(r);
  }

Add a rows in the table

The table API (client-side) offers different ways to add rows in the table:

1: One row, with type check on set value. (you get compile error if you change something in your table):

ITableRow row = getTable().createRow();
getTable().getNameColumn().setValue(row, "Smith");
getTable().getFirstNameColumn().setValue(row, "John");
getTable().getAgeColumn().setValue(row, 42);
getTable().getBirthDateColumn().setValue(row, DateUtility.parse("14.12.1970", "dd.MM.yyyy"));
getTable().addRow(row, true);

The second parameter correspond to "mark as inserted". false (default value - if the parameter is omitted) the row will be insterted with a row Status: ITableRow.STATUS_NON_CHANGED. If true, the row will be inserted with the status ITableRow.STATUS_INSERTED.

2: One row as Object[] array.

getTable().addRowsByArray(
    new Object[]{"Johnny", "Mcgee", 26, DateUtility.parse("25.05.1986", "dd.MM.yyyy")}, 
    ITableRow.STATUS_INSERTED);

The second parameter indicate the status of the new row. ITableRow.STATUS_INSERTED is the default status (it could be omitted in this example).

3: Multiple rows as Object[][] array.

getTable().addRowsByMatrix(new Object[][]{
    new Object[]{"Isabella", "Barton", 32, DateUtility.parse("21.01.1980", "dd.MM.yyyy")},
    new Object[]{"Dana", "Reyes", 56, DateUtility.parse("16.08.1956", "dd.MM.yyyy")}
}, ITableRow.STATUS_INSERTED);

The second parameter indicate the status of the new row. ITableRow.STATUS_INSERTED is the default status (it could be omitted in this example).

For method 2 and 3 you need to be ensure that the array elements order match with the order of your table columns.

Delete a row from the table

In a Table client-side, you have two ways to remove a row:

• deleteRow(..)
• discardRow(..)

deleteRow(..)

the row disappear from Table (as expected by the user), but is still present in the table. You can access it with ITableRow#getDeletedRows(). Later if you export the form content in a TableData, you will get row in the table with the status ITableHolder.STATUS_DELETED and you can persist the deletion in the database.

discardRow(..)

The row is removed from the table and lost. Nothing is sent to the server.

Now if you set AutoDiscardOnDelete to true on the table, calling deleteRow(..) is equivalent to discardRow(..).

The semantic of a discarded row is: the row is deleted + there is no modification to commit to the server. The TableField assume there is no modifications. There is no "saveNeeded" status, the user will not be informed that he has pending modifications on the form...

TODO

TODO
Organize these subsections in section + subsection. Add description

Display/Hide the data (Organize Table)

Table provides support to sort, to filter how the content is represented.

Sorting possibility

properties

Selection

Table also manages selection.

properties

Menu

Table can also contains Menus, to provide a possibility to trigger some actions (Menus are displayed in the context menu of the table).

Summary Cell

In outline based application, the child-pages are represented a nodes in the page tree. The cell of this node is defined by the summary cell of the table.

The set a column as summary cell, the column must override the following method:

      @Override
      protected boolean getConfiguredSummary() {
        return true;
      }

If more than 1 column is defined as summary column, they will be concatenated

Primary Columns

TODO
Describe this here or in the Column property

See Also

• TablePage
• TableField

• Column
• Table row
• Cell