specs/models/M_TABLE_RECORD
Table Record
A Table Record, sometimes called a table row, represents a single object in a table. This object can be anything, but is constrained in that its properties correspond with the fields for this table (see Table Fields for details). Table records correspond with the database concept of a record.
Fields
Because table fields are generated by the user, tables records can have essentially any set of properties a user wants. The only exception is that every record must have an ID field (see Table Fields for details).
| Name | Description |
|---|---|
| Unique ID | A unique text ID for the table record, determined when it is initially created |
| Fields | All possible fields that can be edited for the record, determined by the active Table Fields within the Table |
| Deletion Status | A boolean that determines whether the record is active or deleted |
| Date Created | When the record was created |
| Date Updated | When the record was last updated |
Usage
- Users can add a new record by clicking the Create Record button on the Table Editor page (see Table Editor doc for details). When creating a record, the ID field is required and must be unique. Other fields are optional, but must be of the specified type if included.
- Users can remove a record by right clicking it on the Table Editor page (see Table Editor doc for details). Records deleted this way are permanently deleted and cannot be restored.
- Users can update existing records at any time from the Table Editor page (see Table Editor doc for details). Users can update any field except the ID field.
Tests
| ID | Name |
|---|---|
| QA-T92 | Table Management : 12 - Create table records from the table detail page |
| QA-T93 | Table Management : 13 - Sort table records by column in table view |
| QA-T94 | Table Management : 14 - Load multiple pages of table records in table view |
| QA-T133 | Record Placeholders : 07 - Delete Table Record |
| QA-T464 | Tables CSV Import : 01 - Import to table |
| QA-T466 | Tables CSV Import : 02 - Import feature data handling |
| QA-T467 | Tables CSV Import : 03 - Import from export |
| QA-T596 | Widgets - Record History Widget |
| QA-T701 | Record Placeholders : 07 / Attempting to Delete a Loaded Table Record |
Requirements
| ID | Requirement |
|---|---|
| PLAT-8874 (848) | The ability to discern invalid or altered records. Ability to annotate data is changed. For GMP or critical data changes annotation can be configured as required. |