Difference between revisions of "Increasing the Maximum Size of the Analyst E-Mail Address Field"
Jump to navigation
Jump to search
(Created page with "{{Template:Basic Cover |title=Increasing the Maximum Size of the Analyst E-Mail Address Field |type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |auth...") |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Template:Basic Cover | {{Template:Basic Cover | ||
| − | |title=Increasing the Maximum Size of the Analyst E-Mail Address Field | + | |title=Increasing the Maximum Size of the Analyst E-Mail Address Field |
|type=FAQ | |type=FAQ | ||
|htl=Y | |htl=Y | ||
| Line 8: | Line 8: | ||
|status=Published | |status=Published | ||
|version=1.0 | |version=1.0 | ||
| − | |authors= | + | |authors=Hornbill Support |
| − | |applicableto=Supportworks ESP | + | |applicableto=Supportworks ESP |
}} | }} | ||
| − | |||
| − | |||
| − | To extend the | + | 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. |
| + | |||
| + | Is it advisable to have a backup of the Supportworks System Database before making the alterations below. | ||
| + | |||
| + | 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: | ||
<pre>use sw_systemdb | <pre>use sw_systemdb | ||
alter table swanalysts modify contactE varchar (n);</pre> | alter table swanalysts modify contactE varchar (n);</pre> | ||
| − | where <code>n</code> is the required maximum number of characters. | + | where <code>n</code> is the required maximum number of characters. The upper limit of <code>n</code> is 255. |
Latest revision as of 13:49, 20 August 2015
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | Hornbill Support |
| Applies to: | Supportworks ESP |
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.
Is it advisable to have a backup of the Supportworks System Database before making the alterations below.
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. The upper limit of n is 255.