saltcorn / sql

Actions and views based on SQL
MIT License
0 stars 1 forks source link

SQL query table provider not compatible with ProportionsVis view #4

Open neoguet opened 9 months ago

neoguet commented 9 months ago

I created a SQL query as table provider. It's work well in list view but an error occurred when i try to use a ProportionVis view.

saltcorn_container      | SELECT * FROM "public"."_sc_views" where "name"=$1 order by lower("name") [ 'projet_suivi_financier-graph' ]
saltcorn_container      | Running view projet_suivi_financier-graph with state {}
saltcorn_container      | select sum(mt."montant_engage"), "annee" as "annee" from undefined mt   group by mt."annee" []
postgres_container      | 2024-01-24 23:14:57.564 UTC [4809] ERROR:  relation "undefined" does not exist at character 58
postgres_container      | 2024-01-24 23:14:57.564 UTC [4809] STATEMENT:  select sum(mt."montant_engage"), "annee" as "annee" from undefined mt   group by mt."annee"
saltcorn_container      | error: relation "undefined" does not exist
saltcorn_container      |     at /usr/local/lib/node_modules/@saltcorn/cli/node_modules/pg-pool/index.js:45:11
saltcorn_container      |     at processTicksAndRejections (node:internal/process/task_queues:95:5)
saltcorn_container      |     at proportionsPlot (/plugin_packages/@saltcorn/visualize/proportions-plot.js:287:20)
saltcorn_container      |     at Object.run (/plugin_packages/@saltcorn/visualize/proportions.js:24:10)
saltcorn_container      |     at View.run (/usr/local/lib/node_modules/@saltcorn/cli/node_modules/@saltcorn/data/models/view.ts:457:14)
saltcorn_container      |     at /usr/local/lib/node_modules/@saltcorn/cli/node_modules/@saltcorn/server/routes/view.js:168:22