Need to ADD New Column on Statistics

English! place to talk about OTRS development, programming and coding

Moderator: tto

Post Reply
chaitanyan
OTRS newbie
Posts: 2
Joined: 21 Jun 2018, 22:48
OTRS Version?: 6.0.7

Need to ADD New Column on Statistics

Post by chaitanyan » 28 Jun 2018, 09:26

Hi All,

We have added new State Type "Resolved" on Database table "ticket_state_type" and created Status "Resolved" with new State Type, as would like to keep the field in Ticket Status and require to get Timestamp of Ticket Status updated with "Resolved", in Statistics.

Now, i need to add the new Column of State Type "Resolved" using Attributes of Statistics and would like to get Timestamp of Ticket state updated with "Resolved" in Statistics.

Please help me to achieve my requirement, to get Timestamps of Ticket status updated with State "Resolved" on Statistics.

Product details:

OTRS version - 6.0.7
Apache version - 2.4.6
Database - 5.5.56-MariaDB
Regards,
Chaitanya.

wurzel
OTRS guru
Posts: 2548
Joined: 08 Jul 2010, 22:25
OTRS Version?: 6.0.x

Re: Need to ADD New Column on Statistics

Post by wurzel » 28 Jun 2018, 14:57

Hi,

as far as I know the statistic module can not get this value. It is a timestamp in history table, and the statistic does not use it. Statistic uses ticket information, not history information :-(

You can use SQL queries for this

Or you can use additional (commercial) add ons to get the timestamp of the event. I am using a add on for the generic agent to set a date/time on a ticket. This value is shown in the statistics.

Florian
    ((OTRS)) Community Edition 6.0.x, LAMP LIVE auf Debian 9
    OTRS 7 SILVER

    -- Ich beantworte keine Forums-Fragen PN - No PN please

    I won't answer to unfriendly users any more. A greeting and regards are just polite.

    Post Reply