Applications with TempTable or ProDataset dataslot
BPM Portal displays Dataset dataslot and supports CRUD operations for Dataset(TempTable and ProDataSet) dataslot. Users can View, Add, Edit, and Delete records from a table. Relations between different TempTables are supported while adding or editing a record. Users can see the relation information while performing Create or Edit actions. The Create and Edit windows provide auto populated information for related columns. Child fields have an icon next to them and on clicking these icons, the relation information is displayed at the top of the window. For every child field, a dropdown list menu is shown which has values of the parent field. Users can select the input for a child field only from the available parent field values. If the current value of the child field is no longer present in the parent field, a message is displayed stating that the parent value was deleted. Users can choose to retain the same value or select any other value from the list which is available in the parent field.
Note: While adding or editing, if a parent table is empty, the dropdown list will be empty and a message is displayed stating that the parent table is empty and the Create or Edit button is disabled.
The following limitations apply to performing CRUD operations on Dataset dataslot:
Relations are handled only at the time of adding/editing a record and not when a record is deleted. On deleting parent record, the child record remains in the table.
Recursive relations are not handled in the UI.
Relations are not handled if CRUD operations are performed using APIs from JS Tools or GEL Editor.