[rt-users] Custom database query from within RT

[Renney, Paul]

Firstly, thanks for the reply.

It's good news I can do it using RT's API. The data I am using can be in the RT database.

I have looked for any documentation/examples/tutorials of how to use the API with custom tables but can't find any. Can anyone help here? 

Regards,
Paul
________________________________________
From: rt-users-bounces at lists.bestpractical.com [rt-users-bounces at lists.bestpractical.com] on behalf of Kevin Falcone [falcone at bestpractical.com]
Sent: 02 March 2012 17:37
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Custom database query from within RT

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

Think green - keep it on the screen.

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.