[rt-users] CustomFieldValues Table Question

[Jesse Vincent]

On Mon, Nov 13, 2006 at 09:31:23AM -0500, Rappaport, Evan wrote:
> 
> 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?

Some parts of the UI use it to choose what order to display fields in.
There's no deep magic and nothing bad happens if the value is always 0.

> 
> +---------------+--------------+------+-----+---------+----------------+
> | Field         | Type         | Null | Key | Default | Extra          |
> +---------------+--------------+------+-----+---------+----------------+
> | id            | int(11)      |      | PRI | NULL    | auto_increment |
> | CustomField   | int(11)      |      | MUL | 0       |                |
> | Name          | varchar(200) | YES  |     | NULL    |                |
> | Description   | varchar(255) | YES  |     | NULL    |                |
> | SortOrder     | int(11)      |      |     | 0       |                |
> | Creator       | int(11)      |      |     | 0       |                |
> | Created       | datetime     | YES  |     | NULL    |                |
> | LastUpdatedBy | int(11)      |      |     | 0       |                |
> | LastUpdated   | datetime     | YES  |     | NULL    |                |
> +---------------+--------------+------+-----+---------+----------------+
> 
> Thanks
> 
> Evan Rappaport
> 

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

--