[rt-users] SQL Querries in Scrips

[Asif Iqbal]

On Mon, Dec 19, 2005 at 12:07:22AM, Daniel Kercher wrote:
> Hello together,
> 
> I've todo SQL Querries in RT scrips. I know I could use the FromSQL
> Statement, but I didnt find any description how to get the infos out
> of rt.
> I need to get the Priority and the Final Priority from each Ticket a
> special user own.

You can do it atleast in two steps

rt ls -t ticket "queue='queue-name' and owner='owner-name'

Then collect the ticket ids and run each one like this

rt show -t ticket 12345

Hope that helps

> 
> best regards Daniel
> -- 
>    Gruesse Daniel
> 
> -------------------------------------------------------------------------------
> ie haben die Position Ihres Mauszeigers geaendert. Bitte starten Sie
> Windows neu, damit die Veraenderungen wirksam werden.
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
"..there are two kinds of people: those who work and those who take the credit...try
 to be in the first group;...less competition there."  - Indira Gandhi