Home > Manager

Working with Tables

Adaptation Models can organize Master Data in tables. Tables allow to manage high volumes of data and provide features similar to relational databases.

All the concepts you have learned about reading and editing Master Data can be applied to tables.

Navigate in a table

At the top right side of the table, navigation buttons allow to go to the first / previous / next / last page.

A menu called View , located at the top of the table, allows to perform the following tasks:

Another menu called Action , also located at the top of the table, allows to perform several tasks:

The first time they are displayed, table occurrences are sorted by the primaryKey table columns. A new sort can be done by selecting columns headers. All selected columns are used and the lastly selected column is considered as having the priority. Null values are sorted as minimum values

Note that sort on specific format fields is not yet implemented. Standard format is used.

Master Data in a table can have 2 colors codes:

To view a table record, double click on it.

The icon indicates that the data is part of the primary key.

Edit a table

Edition of Master Data in table works the same way than other data. At the top left side of the table, you can use the button to create a new record.

In form edition mode (default), you have to double-click on an existing record in order to update it. To activate this mode, if it is not the current one, choose Form option in the menu View at the top of the table.

On a table, you can use the buttons at the right side of each record:

Tabular Edition

It is possible to edit Master Data values directly into a table. To activate this mode, choose Tabular option in the menu View at the top of the table.

To edit a record, simply click on it. Note that tabular edition works only on simple types (complex types are too large to display). You must validate or cancel your record updates in order to edit another record. You can also double click on a record if you want to access the detailed form (default mode).

Applying filters and search

Some tables can define filters. Filters allows you to apply select criteria on table contents, in order to restrict the records displayed (see "Add UI component and filter" tutorial for more details).

Multiple filters can be applied at the same time on a table. Only records which match all applied filters will be displayed in the table.

By default, each table comes with a multi-criteria search filter . To show (respectively hide) filters, choose Show Filters (respectively Hide Filters ) in the menu View at the top of the table. You can then configure your search and apply your filter.

Note that to execute a specific filter, you have to select it in the Search menu.

Search features are:

Use cases for numeric fields search

Criteria

Value

Whole word checked

100

100

10100

1.1001

100

1,00

1,000

901,000

no value

1.11

1.11

1.111

901.111

1.11

1 1

no value

no value

1

1.00

no value

Home > Manager