Skip to content

SQL query table provider not compatible with ProportionsVis view #4

@neoguet

Description

@neoguet

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions