Good Morning,
When you run a Statistic report the values of the dynamic field with special characters print in error, the following screen is attached.
Dynamic Fields Statistics
Moderator: crythias
-
airtondetoni
- Znuny newbie
- Posts: 15
- Joined: 07 Jul 2016, 19:52
- Znuny Version: 5.0.13
- Real Name: Airton Toni
- Company: PK
- Contact:
Dynamic Fields Statistics
You do not have the required permissions to view the files attached to this post.
-
airtondetoni
- Znuny newbie
- Posts: 15
- Joined: 07 Jul 2016, 19:52
- Znuny Version: 5.0.13
- Real Name: Airton Toni
- Company: PK
- Contact:
Re: Dynamic Fields Statistics
Can someone help?
-
root
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Dynamic Fields Statistics
What kind of dynamic field is it? Text, Selection, ...
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
airtondetoni
- Znuny newbie
- Posts: 15
- Joined: 07 Jul 2016, 19:52
- Znuny Version: 5.0.13
- Real Name: Airton Toni
- Company: PK
- Contact:
Re: Dynamic Fields Statistics
Remote DB
-
root
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Dynamic Fields Statistics
The ARRAY in the screenshot looks like these are fields with multiple values. I'm pretty sure that this is a display problem.
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
airtondetoni
- Znuny newbie
- Posts: 15
- Joined: 07 Jul 2016, 19:52
- Znuny Version: 5.0.13
- Real Name: Airton Toni
- Company: PK
- Contact:
Re: Dynamic Fields Statistics
It is displaying the error only the value have special characters. I checked directly on the BD and the value is correct.
For example, if the valeu have special characters like â,é,ã the information displayed is ARRAY, but when the valeu doesn't have it is displayed correctly.
For example, if the valeu have special characters like â,é,ã the information displayed is ARRAY, but when the valeu doesn't have it is displayed correctly.
You do not have the required permissions to view the files attached to this post.
-
root
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Dynamic Fields Statistics
I've tested it with a OTRS 5.0.16,and added two values to a DF text and Dropdown, that's my result:
It works for me :-/ Do you have a test system where you can try it with a DF not of type remote db? If you can provide me a database dump (mysql) I would test it for you to check if it's a problem of RemoteDB.
It works for me :-/ Do you have a test system where you can try it with a DF not of type remote db? If you can provide me a database dump (mysql) I would test it for you to check if it's a problem of RemoteDB.
You do not have the required permissions to view the files attached to this post.
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
airtondetoni
- Znuny newbie
- Posts: 15
- Joined: 07 Jul 2016, 19:52
- Znuny Version: 5.0.13
- Real Name: Airton Toni
- Company: PK
- Contact:
Re: Dynamic Fields Statistics
I did the test, it actually displays correctly. I think the problem is in DynamicFieldRemoteDB. Here is the version I'm using from OTRS and the DynamicFieldRemoteDB addon.
DynamicFieldRemoteDB 5.0.3
'DatabaseVersion' => 'MySQL 5.7.15',
' 'OSType' => 'Linux',
'OSVersion' => 'centos 7.3.1611',
'OTRSVersion' => '5.0.13',
'PerlVersion' => '5.16.3',
'SupportDataSending' => 'No'
DynamicFieldRemoteDB 5.0.3
'DatabaseVersion' => 'MySQL 5.7.15',
' 'OSType' => 'Linux',
'OSVersion' => 'centos 7.3.1611',
'OTRSVersion' => '5.0.13',
'PerlVersion' => '5.16.3',
'SupportDataSending' => 'No'