Select all tickets with description field for a queue

[konak0508]

Hi OTRS Team,

I would like in your help with writing an SQL qeury which can get all tickets for a particular Queue with its description field. Can you please help me on this? i m not an pl/sql developer and i have no idea to qeite a query. And is there a way to get all the table names in SQL box? I tried SHOW TABLES but it says otrs.TABLES doesn't exist

Thanks
Karthik

[wurzel]

hi,

why not using the statistics?

Flo

[skullz]

Well if my english is correct, he want to print out ticket with description (i guess 1st article body). Unless default statistic already support 1st article, i think only possible via sql / api.

Hint:
In database, look at table ticket and article

[konak0508]

Hi Wurzel,
I tried the search option and got the csv but the description field was missing.

Hi skullz,

Yes that is correct. I m trying to pull all the tickets for a particular queue with tickets' description too. Thanks for the input. will check on that. I couldn't actually pull the correct table names.

Thank you
Karthik

[crythias]

The schema:
https://ftp.otrs.org/pub/otrs/doc/datab ... tabase.png

Assuming "Description field" is "Title":

Code: Select all

SELECT t.tn AS TicketNumber, t.title AS Description FROM ticket t left join queue q on q.id=t.queue_id where q.name="Raw" LIMIT 40

If "Description" is a Dynamic Field (or, say, the body of the first article) it gets a little tougher.