[SOLVED] Count fetched emails

Moderator: crythias

Locked
dolfiz
Znuny newbie
Posts: 85
Joined: 15 Jan 2014, 21:07
Znuny Version: 3.3.3
Location: Italy

[SOLVED] Count fetched emails

Post by dolfiz »

Hi all,

is there a way to simply count ALL the fetched emails? And I mean all, regardless if they will become new tickets, or just articles of existing tickets.

Thanks,
Dolfiz
Last edited by dolfiz on 16 Apr 2014, 13:59, edited 1 time in total.
OTRS 3.3.3 - Ubuntu server 12.04 - MySQL
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Count fetched email

Post by jojo »

select count(*) from article where article_type_id=1 and article_sender_type_id=3;
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
dolfiz
Znuny newbie
Posts: 85
Joined: 15 Jan 2014, 21:07
Znuny Version: 3.3.3
Location: Italy

Re: Count fetched email

Post by dolfiz »

jojo wrote:select count(*) from article where article_type_id=1 and article_sender_type_id=3;
I'm feeling dumb... I was missing the sender_type condition :D

Thank you jojo for your time ;)
Dolfiz
OTRS 3.3.3 - Ubuntu server 12.04 - MySQL
Locked