SQL Querries in Scrips

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.

best regards Daniel
Gruesse Daniel

ie haben die Position Ihres Mauszeigers geaendert. Bitte starten Sie
Windows neu, damit die Veraenderungen wirksam werden.

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

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
Thank you for the fast reply. But the mysql Querries should be done
in a rt perl script.
I could use the normal DBI function for this but I think it’s easier
to take the FromSQL Statement.
Have anybody a link where I get the syntax or from which I get the
info via perldoc?

regards daniel