Increasing the Maximum Size of the Analyst E-Mail Address Field
Jump to navigation
Jump to search
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | HTL QA |
| Applies to: | Supportworks ESP up to Version 7.4.1 (then in on-line help) |
Increasing the Maximum Size of the Analyst E-Mail Address Field
By default, the maximum number of characters you can have in an analyst's e-mail address, as stored in the swanalysts table, is 32. If you attempt to enter more than this in the relevant field of the Analyst Properties form, you will find, on reading back the record, that the address has been truncated.
To extend the maximum size, run the Interactive SQL utility by selecting Start > All Programs > Hornbill Core Services > Interactive SQL and enter the following SQL command:
use sw_systemdb alter table swanalysts modify contactE varchar (n);
where n is the required maximum number of characters.