Additional database fields

RT Users
1

Has anyone experimented with adding extra fields to the rt database? I
have a user requesting that a location field be added to our work request
system. Currently the location is just written into the history/comments
of the ticket. If anyone has had any experience with this or would like to
help me tackle it, I would greatly appreciate it.

Brad Pinkston
Centenary College of LA
Firewall/Network Administrator
IT Department
(318) 869-5003
bpinksto@centenary.edu

2

Has anyone experimented with adding extra fields to the rt database?
I have a user requesting that a location field be added to our work request
system. … If anyone has had any experience with this or would like to
help me tackle it, I would greatly appreciate it.

Yes. It’s not too difficult if it’s just a simple text field.

I added a ‘Department’ to my Users table so that I could make
the home page appear differently for people in different departments
within our company.

Here it is in a nutshell. YMMV

Add the column

ALTER TABLE Users Add Department  varchar(16);

User.pm
Add the column to the %Cols block in _Accessible

	# {{{ ICS additions
	Department => 'public/read/write',
	# }}}

CurrentUser.pm
same kind of thing

Pick a page where I can edit it (WebRT/html/Admin/Users/Modify.html
in this case)

  Unix login: <input name="Gecos" value="<%$UserObj->Gecos%>">
  <BR>
+ Department: <input name="Department" value="<%$UserObj->Department%>">
+ <BR>
  Extra info: <textarea name="FreeformContactInfo" cols=20 rows=5>...
  <& /Elements/TitleBoxEnd &>

Good luck.

-Tony Aiuto