Hi There!

How can I identify the requestor of the ticket on my mysql database?  On
Tickets table, there is not a field like "requestor"!

Any suggestion is appreciated..

Marcelo Calado





Field           | Type         | Null | Key | Default      | Extra
|
+-----------------+--------------+------+-----+--------------+--------------
--+
| id              | int(11)      | NO   | PRI | NULL         |
auto_increment |
| EffectiveId     | int(11)      | NO   | MUL | 0            |
|
| IsMerged        | smallint(6)  | YES  |     | NULL         |
|
| Queue           | int(11)      | NO   | MUL | 0            |
|
| Type            | varchar(16)  | YES  |     | NULL         |
|
| IssueStatement  | int(11)      | NO   |     | 0            |
|
| Resolution      | int(11)      | NO   |     | 0            |
|
| Owner           | int(11)      | NO   | MUL | 0            |
|
| Subject         | varchar(200) | YES  |     | [no subject] |
|
| InitialPriority | int(11)      | NO   |     | 0            |
|
| FinalPriority   | int(11)      | NO   |     | 0            |
|
| Priority        | int(11)      | NO   |     | 0            |
|
| TimeEstimated   | int(11)      | NO   |     | 0            |
|
| TimeWorked      | int(11)      | NO   |     | 0            |
|
| Status          | varchar(64)  | YES  |     | NULL         |
|
| TimeLeft        | int(11)      | NO   |     | 0            |
|
| Told            | datetime     | YES  |     | NULL         |
|
| Starts          | datetime     | YES  |     | NULL         |
|
| Started         | datetime     | YES  |     | NULL         |
|
| Due             | datetime     | YES  |     | NULL         |
|
| Resolved        | datetime     | YES  |     | NULL         |
|
| LastUpdatedBy   | int(11)      | NO   |     | 0            |
|
| LastUpdated     | datetime     | YES  |     | NULL         |
|
| Creator         | int(11)      | NO   |     | 0            |
|
| Created         | datetime     | YES  |     | NULL         |
|
| Disabled        | smallint(6)  | NO

---------
RT 4.4 and RTIR Training Sessions 
(http://bestpractical.com/services/training.html)
* Hamburg Germany - March 14 & 15, 2016
* Washington DC - May 23 & 24, 2016

Reply via email to