On Fri, Mar 02, 2012 at 01:54:08PM +0000, Renney, Paul wrote: > On the create ticket form I need to act upon a change to a drop down menu > for a custom field > (for this example 'Customer'), look up this value in a database table for > a resulting default > priority, and change the value in the priority drop down. > > Ordinarily this wouldn't be hard in a basic HTML form, creating a db > connection manually, but > I can't find where to start doing this within RT. I'm not sure where I > should be putting my db > query code. Does RT allow me to put in a custom query somewhere and handle > the db connection? > Would a scrip be suitable to do what I need? > > I've searched the mailing list and tutorials but can't find a similar > problem. Specific files > to change and alternative ideas on how do this would be appreciated as I > am new to RT.
Are you doing your lookup inside RT's database or using an external database? It sounds like you either want code using RT's API or a DB connection running inside a Scrip. -kevin
pgpW2h8HQZdrV.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012