Mysql table join node.js Chart not working

Wappler General Bugs
#1

I have-

-3 tables: tracks, members, journals

-A custom query (which shows query results)
image

-Doughnut Chart
json data returned to chart=
{“account”:“account”,“home”:“Beyond-Meditation: home”,“dashboard”:“dashboard”,“custom”:[{“j.count”:1,“category”:“mindfulness”},{“j.count”:6,“category”:“energise”},{“j.count”:1,“category”:“anxiety”}]}

But values not displaying in the chart itself…

image
image722×286 8.82 KB

Question: Is there a problem with charts or have I not configured this properly??

I have also found that the expression is NOT being saved in custom query parameters. (Is this a known bug?)

Any help would be appreciated :slight_smile:

Wappler 4.3.2 Released
#2

Ok found problem in custom query…count As ‘count’ not ‘j.count’.
image

!! However Bug remains- Expression does not save. !!

image

#3

Just turn off the experimental features and it will save properly.

1 Like
#4

Great Teodor…that all works!

#5

This will be solved in the next update.

#6

This has been fixed in Wappler 4.3.1

1 Like
#7
#8

This topic was automatically closed after 2 days. New replies are no longer allowed.