Layton ServiceDesk - Configuring the System - Data Design
m (moved Layton ServiceDesk™ - Data Design to Layton ServiceDesk™ - Configuring the System - Data Design: Standardised name) |
(Major reformat) |
||
| Line 1: | Line 1: | ||
| − | + | <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> | |
| + | Previous article in this series: '''[[Layton ServiceDesk™ - Configuring the System - Create and Define Libraries|Create and Define Libraries]]''' | ||
| + | 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 format, showing the Field Name, Type and Size. The option to delete fields will not be available against system fields, prefixed ''sys_''. | |
| − | + | To add a data field, click the ''Add New'' button. You are then presented with a form to enter the Field Name, Type (Text, Integer, Currency, Date, etc) and Size and when completed, click ''Save''. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | To add a data field | + | |
| − | The Field Names do not have to the same as the Form name or label | + | The Field Names do not have to the same as the Form name or label. Any field you do add in data design must be prefixed ''usr_''. |
| − | Once a user defined data | + | 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 floating Toolbar in the Form Design interface. |
| + | |||
| + | Next article in this series: '''[[Layton ServiceDesk™ - Configuring the System - Form Design|Form Design]]''' | ||
| + | <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> | ||
Revision as of 00:48, 29 March 2011
Previous article in this series: Create and Define Libraries
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 format, showing the Field Name, Type and Size. The option to delete fields will not be available against system fields, prefixed sys_.
To add a data field, click the Add New button. You are then presented with a form to enter the Field Name, Type (Text, Integer, Currency, Date, etc) and Size and when completed, click Save.
The Field Names do not have to the same as the Form name or label. Any field you do add in data design must be prefixed usr_.
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 floating Toolbar in the Form Design interface.
Next article in this series: Form Design
