Forum GLPI-Project

danh

Member

From: Chicago, USA

Registered: 2012-03-08

Posts: 546

Website

Need SQL help for custom report

I am trying to create a report that shows all tickets with 'system edit' in the name and also show validations associated with the tickets.

I have the first part down:

select name,date,closedate,status,content 
from glpi_tickets 
where name like '%system edit%' 
order by closedate

But I do not know how to join the table ticketvalidation.

I'd like to get comment_validation, status, validation_date

---

Thanks,
Dan

danh

Member

From: Chicago, USA

Registered: 2012-03-08

Posts: 546

Website

Re: Need SQL help for custom report

- bump -

---

Thanks,
Dan

danh

Member

From: Chicago, USA

Registered: 2012-03-08

Posts: 546

Website

Re: Need SQL help for custom report

I have solved this - I don't know SQL too well, so I setup a test access db and got the query to work and then copied and modded the sql stmt from that.

---

Thanks,
Dan