[rt-users] Custom Field validation rules

2009-09-28 Thread Mike Johnson
What version of RT was validation rules for custom fields added?
 
I've done some googling, and I found that 3.8 definitely has the ability to 
make fields manditory, as well as using regular expressions to validate the 
data entered in them all done through the web interface.
 
I'm just curious as to what version of RT that was added.  I went to Best 
Practical's site and couldn't find a patch log type of thing for me to search 
through :D
 
Thanks!
 
 
 
Mike Johnson
Datatel Programmer/Analyst
Northern Ontario School of Medicine
955 Oliver Road
Thunder Bay, ON   P7B 5E1
Phone: 807.766.7331
Email: mike.john...@normed.ca 
Technology assistance: email nosmhelpd...@normed.ca 
Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat holidays: 
Off campus toll free 1-800-461-8777, option 8, or locally either 
(705)-662-7120 or (807)-766-7500
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Custom Field validation rules

2009-09-28 Thread Kevin Falcone
On Mon, Sep 28, 2009 at 02:01:40PM -0400, Mike Johnson wrote:
What version of RT was validation rules for custom fields added?
 
I've done some googling, and I found that 3.8 definitely has the ability 
 to make fields
manditory, as well as using regular expressions to validate the data 
 entered in them all done
through the web interface.
 
I'm just curious as to what version of RT that was added.  I went to Best 
 Practical's site and
couldn't find a patch log type of thing for me to search through :D

You'll find git log is your friend here, but there is an even simpler
solution for schema changes

rt/3.8/etc/upgrade (3.8-trunk)$ grep Pattern */schema*
3.3.0/schema.Oracle:ALTER TABLE CustomFields ADD Pattern VARCHAR2(255)
NULL;
3.3.0/schema.Pg:alter table CustomFields add column Pattern
varchar(255) NULL;
3.3.0/schema.mysql:alter table CustomFields add column Pattern
varchar(255) NULL;

They were later upgraded to 255 char fields

-kevin


pgpmLJLD10mZE.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com