OVERVIEW
Users can add, update, delete the system table values for different system tables in the Admin which are used in Item management.
ADD THE SYSTEM TABLE VALUE
- Select System Tables from System Customization in Admin
- List of System Tables defined by Orcanos and User-defined tables gets displayed
- Click on View icon or Code hyperlink to open the system table values
- Click on Add icon at the bottom right side of the page
- Input the Description
- Description: Name of the value – which the user selects from the selection list
- Color: Click the Color field to select the code color.
- Is Default: Selecting the checkbox ensures this value is selected when an item is created.
- Is Active: On selecting this checkbox every status gets the indication if it is active or complete.
- Is Complete: This is only for the purpose of status. Selecting this checkbox ensures that If the work item has reached a specific status, it is marked as completed.
- Is Freeze: Selecting this checkbox prevents you from modifying the work item in this specific status.
- Click Next to add another system table value, Previous icon to go to the previous item or Save Button.
User can import list of system table values from .csv or .xlsx files using Import System table Values option
UPDATE THE SYSTEM TABLE VALUE
- Click on Edit icon against a value to update from Action Column
- Update the Description and checkbox selection
- Press Save button
Click on Previous or Next icon, to update multiple values at one go
DELETE THE SYSTEM TABLE VALUE
- Click on Delete icon against a value to remove from Action Column
- When no record is associated with the deleted value, it is removed directly.
- When a record is associated with a deleted value, a pop-up is displayed to assign it to a new value
Default System table value is allowed to delete after selecting new value as “Is Default”
All System table values cannot be deleted from the system table
For some System defined system tables such as ‘Risk Severity level’, ‘Risk Probability level’ etc. the values cannot be Updated or Deleted.
ACTIONS ON THE SYSTEM TABLE VALUES
- Move First – Moves the value to the first order in the table
- Move Up – Moves the value above the immediate value in the table.
- Move Down – Moves the value below the immediate value in the table.
- Move Last – Moves the value to the last order in the table.
- Add After – Allows to add a value in the middle of the list of the existing system table values
WORK ITEM LIST AUTOMATION Generated SYSTEM TABLES
Users are unable to add or import values into these system tables.
RELATED LINKS