[Solved]Show Customer properties in OTRS Stats

Moderator: crythias

Post Reply
marcosaurelio
Znuny expert
Posts: 185
Joined: 08 May 2014, 16:05
Znuny Version: 6.0.10
Real Name: Marcos Aurelio Silverio
Company: Infracerta
Location: Brazil
Contact:

[Solved]Show Customer properties in OTRS Stats

Post by marcosaurelio »

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
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Show Customer properties in OTRS Stats

Post by jojo »

No, as these are no Ticket values
"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
skullz
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Show Customer properties in OTRS Stats

Post by skullz »

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
Znuny expert
Posts: 185
Joined: 08 May 2014, 16:05
Znuny Version: 6.0.10
Real Name: Marcos Aurelio Silverio
Company: Infracerta
Location: Brazil
Contact:

Re: Show Customer properties in OTRS Stats

Post by marcosaurelio »

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
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Show Customer properties in OTRS Stats

Post by skullz »

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
Znuny expert
Posts: 185
Joined: 08 May 2014, 16:05
Znuny Version: 6.0.10
Real Name: Marcos Aurelio Silverio
Company: Infracerta
Location: Brazil
Contact:

Re: Show Customer properties in OTRS Stats

Post by marcosaurelio »

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