Bar chart not displaying output from DB

Ignition
1

Hello all,

I am experiencing difficulties when trying to display result from SQL query from database (result of the query is on image below. I would like to display these values in bar-chart (1st column should be category (i.e. label for X axis) and 2nd-last column should be value) - it means for one category, three bars would be displayed. I thought this is gonna be no-brainer (15 seconds to configure the bar chart), but I am failing to see what am I doing wrong (I had to hide values in column projectnumber).

Behavior of the bar char is as follows:

  1. I enter the SQL query to the data atribute
  2. click OK
  3. data atribute does not change at all - like I haven’t changed anything.

obrazek

Please advise. Thank you in advance.

Take care,
SZ

2

Show your binding configuration for this.

3

Hello, I have this:

obrazek
obrazek393Ă—591 24.4 KB

After clicking OK, I don’t get any error, the bart chart sticks with the default preview (energy statistics that you see when you drag&drop the chart from toolbox on the window).

In SQL Management studio, the query runs under 1 second returning data almost immediately.

Thank you in advance for any hints, take care.
SZ

4

Actually the more complete picture looks as follows:

obrazek
obrazek1030Ă—616 52.9 KB

5

Without seeing the query itself, I can’t see any reason for the behavior described. If you can’t show it here, you might want to open a support ticket.

1 Like
6

Sorry, I can’t post the query here - maybe I could be tracked to certain company and it wouldn’t be cool if this query could be related to certain company… the query itself is presumably OK without any errors, it runs in SMSS flawlessly.

I will open the ticket than.

Thank you for the effort anyway.
SZ

7

Some syntax legal in a DB's native tool may not be valid in a JDBC driver. Try running your query in the Ignition Designer's Query Browser.

8

It is legal in Ignition as well, that’s why I find it sooo odd:
obrazek

In case Ignition DB Browser would return error, I would be perfectly OK with that.

9

Hmm. Odd indeed. Does anything show up in the designer’s console when you edit the binding? Some kinds of errors only show there, not in a popup.

1 Like
10

You are awesome !!! The console was full of warnings saying that values in the first rows (and presumably also in the other rows) has to be number (whereas some of the numbers were NULL instead).

I changed NULLs to 0 with COALESCE and we have data:

obrazek
obrazek732Ă—356 12 KB

Thank you very much, help much appreciated!

2 Likes