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
[SOLVED] Count fetched emails
Moderator: crythias
[SOLVED] Count fetched emails
Last edited by dolfiz on 16 Apr 2014, 13:59, edited 1 time in total.
OTRS 3.3.3 - Ubuntu server 12.04 - MySQL
Re: Count fetched email
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Count fetched email
I'm feeling dumb... I was missing the sender_type conditionjojo wrote:select count(*) from article where article_type_id=1 and article_sender_type_id=3;

Thank you jojo for your time

Dolfiz
OTRS 3.3.3 - Ubuntu server 12.04 - MySQL