Date format ?

Question

Hi,

I've a dataset from Postregresql with different data type: varchar, integer, timestamp.

When I create the dataset no problems occurs in preview but when I try to create a cockpit with table or chart widget there are 2 issue:

1. Data field is not correctly compiled

2. It's impossible to visualize data info in the chart

This is the result in the cockpit 

Thank you

Answer 1

Thanks for reporting this. Are you using ChartJS or Highcharts?

Would you mind to file an issue on our bug tracker at https://knowage-suite.com/jira/ ? After that, we can investigate it and track its fixing.

Comments

I'm using ChartJS at the moment

---

I've opened a new ticket on your bug tracker JIRA.
Tks

Answer 2

Hi,

    I've successfully loaded into cockpits timestamp values (with or without timezone) from PostgreSQL 9.5 using the default JDBC driver postgresql-9.3-1101.jdbc3.jar provided within installer CE, both in tables and charts (on X axis). Please share your system config if you're still experiencing those issues.

About X asis labels, they're very compressed, I'm sure you can play with options at your choice.

Best regards,

Francesco

Comments

HI, I can't :-(
The only way is to transform timestamp into varchar(). I'm able to filter from data x to data y but when I put timestamp into a table I can read only 01/01/1970

Best regards

---

Hi, could you share your system config please?
I would like to investigate further...

Francesco

---

Hi Francesco,

thank you for your support.

what's the file you need?

M.

---

Hi Marco,
    I mean: operating system & version, JDK version, PostgreSQL version, JDBC driver version... that's all maybe.
Best regards,

Francesco

---

Hi Francesco,

OS: Windows Server 2012 R12
JDK: jre1.8.0_131
JDBC:
Postgresql: 9.5
About JDBC I can find two file for Postgres:
...\Knowage-Server-CE\webapps\qbecore\lib\jdbc\postgresql-9.3-1101.jdbc3.jar and in
...\Knowage-Server-CE\lib\postgresql-9.4-1203.jdbc4.jar

Marco