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.
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