[Solved]Show Customer properties in OTRS Stats

Moderator: crythias

Post Reply
marcosaurelio
OTRS wizard
Posts: 184
Joined: 08 May 2014, 16:05
OTRS Version?: 6.0.10
Real Name: Marcos Aurelio Silverio
Company: Infracerta
Location: Brazil
Contact:

[Solved]Show Customer properties in OTRS Stats

Post by marcosaurelio » 24 Feb 2016, 20:28

Hey Guy,

I need to show a Customer properties (Like Street, Zip, Country) in axis X (Stats Module), is that possible? OTRS version is 5
ScreenHunter_164 Feb. 24 15.24.jpg
Regards
Marcos
You do not have the required permissions to view the files attached to this post.
Last edited by marcosaurelio on 04 Mar 2016, 22:02, edited 1 time in total.
OTRS 6.0.10 Centos 7 Mysql 5.6
Videos de OTRS no Youtube: https://www.youtube.com/channel/UCscGon ... 7hADe3AalA
http://infracerta.com.br

jojo
Moderator
Posts: 14592
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Show Customer properties in OTRS Stats

Post by jojo » 24 Feb 2016, 22:33

No, as these are no Ticket values
"Production": 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 :: Share your ideas

skullz
OTRS wizard
Posts: 180
Joined: 24 Feb 2012, 03:58
OTRS Version?: OTRS 6

Re: Show Customer properties in OTRS Stats

Post by skullz » 25 Feb 2016, 05:57

It is possible for the new ticket..

Use the DynamicField From Customer User features..
This should capture customer user data into ticket dynamic field..

good luck

marcosaurelio
OTRS wizard
Posts: 184
Joined: 08 May 2014, 16:05
OTRS Version?: 6.0.10
Real Name: Marcos Aurelio Silverio
Company: Infracerta
Location: Brazil
Contact:

Re: Show Customer properties in OTRS Stats

Post by marcosaurelio » 25 Feb 2016, 14:29

skullz wrote:It is possible for the new ticket..

Use the DynamicField From Customer User features..
This should capture customer user data into ticket dynamic field..

good luck
Hi skullz, thanks for the answer, but could you be more specific? For now I could extract those infos using SQL querys, but using the report is the easiest way for managers.
OTRS 6.0.10 Centos 7 Mysql 5.6
Videos de OTRS no Youtube: https://www.youtube.com/channel/UCscGon ... 7hADe3AalA
http://infracerta.com.br

skullz
OTRS wizard
Posts: 180
Joined: 24 Feb 2012, 03:58
OTRS Version?: OTRS 6

Re: Show Customer properties in OTRS Stats

Post by skullz » 25 Feb 2016, 15:34

marcosaurelio wrote:
Hi skullz, thanks for the answer, but could you be more specific? For now I could extract those infos using SQL querys, but using the report is the easiest way for managers.
https://otrs.github.io/doc/manual/admin ... stomeruser

*as i stated earlier, only for new ticket..unless you want to re-updating the bunch an old ticket with customer user again..

marcosaurelio
OTRS wizard
Posts: 184
Joined: 08 May 2014, 16:05
OTRS Version?: 6.0.10
Real Name: Marcos Aurelio Silverio
Company: Infracerta
Location: Brazil
Contact:

Re: Show Customer properties in OTRS Stats

Post by marcosaurelio » 25 Feb 2016, 18:44

skullz wrote:
marcosaurelio wrote:
Hi skullz, thanks for the answer, but could you be more specific? For now I could extract those infos using SQL querys, but using the report is the easiest way for managers.
https://otrs.github.io/doc/manual/admin ... stomeruser

*as i stated earlier, only for new ticket..unless you want to re-updating the bunch an old ticket with customer user again..
Cool, Ill take a look, thank you very much.
OTRS 6.0.10 Centos 7 Mysql 5.6
Videos de OTRS no Youtube: https://www.youtube.com/channel/UCscGon ... 7hADe3AalA
http://infracerta.com.br

Post Reply