Report of tickets way in

[SuperDOS]

Hi,

I wonder if there is some way to build a report that get statistics of how many tickets created are either phone/email/web.
Want to figure out which "way in" is most used.

This information is stored in the article so maybe you need to create a custom SQL-query.

Any ideas?

[SuperDOS]

Looked at the database and guess that I'd need to fetch tickets that have article_type_id 1 (email-external) as the first article.
This would get me a list of how many tickets are emailbased tickets.

tried

Code: Select all

SELECT 
  article.id, 
  article.article_type_id AS "1", 
  ticket.id, 
  ticket.title, 
  ticket.tn
FROM 
  public.article, 
  public.ticket;

But not sure how I could make the query just list tickets with email-external as the first article...

Anyone good at SQL-queries?