Layton ServiceDesk - Configuring the System - Data Design
(Added internal link, image, modified text) |
m (Added section headings) |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
| − | <p align="right">[[File:btn_back_up.png|link= Layton | + | <p align="right">[[File:btn_back_up.png|link= Layton ServiceDesk - Configuring the System - Create and Define Libraries]] [[Layton ServiceDesk - Configuring the System - Create and Define Libraries |<U>Previous article in this series: ''Create and Define Libraries''</u>]]</p> |
| − | + | __FORCETOC__ | |
| + | =Overview= | ||
The Data design function provides Administrative users with the ability to add user-defined fields to data tables in the Layton ServiceDesk database tables, although system fields (fields prefixed ''sys_'') cannot be deleted. | The Data design function provides Administrative users with the ability to add user-defined fields to data tables in the Layton ServiceDesk database tables, although system fields (fields prefixed ''sys_'') cannot be deleted. | ||
| Line 23: | Line 24: | ||
All data tables are displayed in the same grid view, showing the Field Name, Type (type of data) and Size (number of maximum characters). The Delete button [[File:Lsd delete 16px.png|link=]] will not appear next to system fields, which are prefixed with ''sys_''. | All data tables are displayed in the same grid view, showing the Field Name, Type (type of data) and Size (number of maximum characters). The Delete button [[File:Lsd delete 16px.png|link=]] will not appear next to system fields, which are prefixed with ''sys_''. | ||
| + | =Adding a User-Defined Field= | ||
To add a data field, click the Add button [[File:Lsd btn plus.png|link=]]. A form will open to enter the Field Name, Type (Text, Integer, Currency, Date, etc) and Size and when completed, click the Save button [[File:Lsd btn save.png|link=]]. | To add a data field, click the Add button [[File:Lsd btn plus.png|link=]]. A form will open to enter the Field Name, Type (Text, Integer, Currency, Date, etc) and Size and when completed, click the Save button [[File:Lsd btn save.png|link=]]. | ||
| Line 31: | Line 33: | ||
| − | Once a user-defined data field has been added to the database table, it can be added to forms by clicking the Add User Field button [[File:Lsd btn toolbar user 32px.png|link=]] on the Toolbar in '''[[Layton | + | Once a user-defined data field has been added to the database table, it can be added to forms by clicking the Add User Field button [[File:Lsd btn toolbar user 32px.png|link=]] on the Toolbar in '''[[Layton ServiceDesk - Configuring the System - Form Design#Using the Form Design Toolbar|the Form Design interface]]'''. |
| − | <p align="right">[[Layton | + | <p align="right">[[Layton ServiceDesk - Configuring the System - Form Design |<u>Next article in this series: ''Form Design''</u>]] [[File:Btn forward.png|link=Layton ServiceDesk - Configuring the System - Form Design]]</p> |
| − | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
Latest revision as of 22:57, 30 October 2016
Previous article in this series: Create and Define Libraries
Contents |
[edit] Overview
The Data design function provides Administrative users with the ability to add user-defined fields to data tables in the Layton ServiceDesk database tables, although system fields (fields prefixed sys_) cannot be deleted.
The default data structures may be adequate, and therefore there will be no requirement to add any user defined fields. Examination of each table under Administration > Data Design will allow decisions to be made on any changes.
You must create any new data fields before you can add them to a form design. The following data tables can be viewed and edited (Note that the Problem, Change & Company data tables will only be available if these features have been turned on in Administration > System Settings > Application Settings):
- Task Data
- Request Data
- Problem Data
- Change Data
- Analyst Data
- End User Data
- Company Data
- Department Data
- Site Data
- Solution Data
- Priority Data
- Survey Data
All data tables are displayed in the same grid view, showing the Field Name, Type (type of data) and Size (number of maximum characters). The Delete button 
will not appear next to system fields, which are prefixed with sys_.
[edit] Adding a User-Defined Field
To add a data field, click the Add button 
. A form will open to enter the Field Name, Type (Text, Integer, Currency, Date, etc) and Size and when completed, click the Save button 
.
Any field you do add in data design must be prefixed usr_. Use only lower-case letters, numbers and the underscore _. On a form, a more descriptive label can be used. For example, the constraints of database design require a field to be called usr_smk_code, but on the form, the field can be given the label SMK Code.
Once a user-defined data field has been added to the database table, it can be added to forms by clicking the Add User Field button 
on the Toolbar in the Form Design interface.
