<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>CustomFieldValues Table Question</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">I am looking at the RT database table for CustomFieldValues and I am wondering about the SortOrder field. I am trying to create a script that will automatically add potential values for some custom fields and I'm not sure what the SortOrder field should be. How is the field used?</FONT></P>
<P><FONT SIZE=2 FACE="Courier">+---------------+--------------+------+-----+---------+----------------+</FONT>
<BR><FONT SIZE=2 FACE="Courier">| Field | Type | Null | Key | Default | Extra |</FONT>
<BR><FONT SIZE=2 FACE="Courier">+---------------+--------------+------+-----+---------+----------------+</FONT>
<BR><FONT SIZE=2 FACE="Courier">| id | int(11) | | PRI | NULL | auto_increment |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| CustomField | int(11) | | MUL | 0 | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| Name | varchar(200) | YES | | NULL | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| Description | varchar(255) | YES | | NULL | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| SortOrder | int(11) | | | 0 | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| Creator | int(11) | | | 0 | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| Created | datetime | YES | | NULL | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| LastUpdatedBy | int(11) | | | 0 | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">| LastUpdated | datetime | YES | | NULL | |</FONT>
<BR><FONT SIZE=2 FACE="Courier">+---------------+--------------+------+-----+---------+----------------+</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier">Thanks</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier">Evan Rappaport</FONT>
</P>
</BODY>
</HTML>