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:
-
Show or hide filters .
-
Use form or tabular edition mode.
-
By default, a table displays 10 occurrences by page. Sub-options of option Show records of menu View allow to change the number of displayed occurrences by page.
Another menu called Action , also located at the top of the table, allows to perform several tasks:
-
Select records: all or none
-
Services on selected records: compare, apply last modification(s).
-
Services on table: print table contents.
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:
-
A light blue data indicates that the value inherits from the parent adaptation. The icon
is displayed. -
A yellow data indicates that the value has been defined in the current adaptation (overwrites inherited value). The icon
is displayed.
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:
-
Duplicate a record -
Derivate a record. Derivation is a complex concept: it allows you to create a new record that inherits from another record. Usually, derivation is not available on tables.
-
Delete or Occult. If the record has been created in the current adaptation, you can delete it. If it overwrites the record inherited from a parent adaptation, you cannot delete it, but you can "occult" it.
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:
-
Type one or more search criteria
-
Select multiple fields (columns of your table)
-
Case sensitive
-
Whole word
-
Code only (for values whose display adds a user label, for example enumerations, nomenclatures or references to table records – if this option is activated, labels are ignored by the search, only underlying values are taken into account)
Use cases for numeric fields search
|
Criteria |
Value |
Whole word checked |
|
|
100 10100 1.1001 |
100 |
|
|
1,000 901,000 |
no value |
|
|
1.11 1.111 901.111 |
1.11 |
|
|
no value |
no value |
|
|
1.00 |
no value |
Home > Manager