Comments (4)
The Chart panel on the report builder is only shown if the data on the results panel has at least one numeric column. What is the data type of the units_in_stock column? Is it one of the data types listed in the IsNumericType function in tools.js:
tools.IsNumericType = function (theType) {
switch (theType.toUpperCase()) {
case "INTEGER":
case "INT":
case "SMALLINT":
case "TINYINT":
case "MEDIUMINT":
case "BIGINT":
case "DECIMAL":
case "NUMERIC":
case "FLOAT":
case "DOUBLE":
case "REAL":
case "MONEY":
case "SMALLMONEY":
case "DOUBLE PRECISION":
case "SMALLSERIAL":
case "SERIAL":
case "BIGSERIAL":
case "INT4":
case "INT8":
return true;
default:
return false;
}
}
It may be that we need to add a new datatype to that list.
from querytree.
It was the products.units_in_stock which is a smallint - from this test database:
https://github.com/pthom/northwind_psql/blob/master/northwind.sql
I'll look into it some more
from querytree.
I setup Northwind and connected QueryTree. From the details you've given I think you've selected the Products.UnitsInStock column and the Suppliers.CompanyName columns, which is what I've done here. The Add Chart button seems to be showing ok for me. Am I doing something wrong?
from querytree.
Right thanks - sorry, looks like I have an older version, but I thought I downloaded the latest release
from querytree.
Related Issues (20)
- All columns from all tables in filter dropdowns instead of only selected columns HOT 1
- hostpolicy.dll is missing HOT 1
- cannot connect to either mysql or sql express on my PC HOT 1
- Can't see the option to use Advanced Reporting HOT 1
- Write my own sql Queries HOT 1
- Error during connectin to PostgreSQL: SSL is required HOT 2
- postgresql connection strings: support "sslmode" parameter HOT 1
- New tables/Views added to database not showing HOT 2
- Cannot install QueryTree from source HOT 1
- "No tables found" in PostgreSQL connection HOT 6
- Team Invite post failing with 404 error HOT 1
- Caution using this in production - scheduled emails creates many long running queries HOT 1
- Multi tenant situation HOT 2
- Advanced report builder is missing, no link displayed next to simple report builder header. HOT 1
- how to deploy query tree HOT 2
- how to integrate/embeded it into existing app (angular 14)
- QueryTree dotnet version update in Dockerfile breaks invitation HOT 1
- Scheduled reports error on save HOT 2
- Querytree
- QueryTree Documentation Empty - No content displayed
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from querytree.