Hi
Anyone know what "query" to an SQL query in the OTRS database 5 (Mysql) to bring the information from all open tickets with all fields? Similar to "report 10003".
Thank you!
Query SQL Tickets
Moderator: crythias
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Query SQL Tickets
wow. What constitutes "all"? but if you insist,
first you might want to look at viewtopic.php?t=16009#p77686
and maybe
first you might want to look at viewtopic.php?t=16009#p77686
and maybe
Code: Select all
select * from ticket left join ticket_state on ticket.ticket_state_id = ticket_state.id where ticket_state.type_id=2OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
daviknx
- Znuny newbie
- Posts: 38
- Joined: 12 May 2015, 21:15
- Znuny Version: 4.0.7
- Real Name: Davi
- Company: Home
Re: Query SQL Tickets
Hi
The query works!:
select * from ticket left join ticket_state on ticket.ticket_state_id = ticket_state.id where ticket_state.type_id=2
Thank you!!
The query works!:
select * from ticket left join ticket_state on ticket.ticket_state_id = ticket_state.id where ticket_state.type_id=2
Thank you!!