Wappler 5.3.1
PostgrSQL 13
Node 14
have created a custom query using crosstab().
have already enabled tablefunc extension on DB Server.
have just one schema on the DB server that is called app.
upon running the query on dBeaver, it returns results as expected.
but when running the exact same query on Wappler via a custom query step, it throws error:
function crosstab(unknown, unknown) does not exist
please help here. looks like a Wappler bug!
Are you using custom database schema and not public? And the functions are applied there? Maybe just add the custom schema prefix then
yes, using custom schema. it is defined on both globals and db manager.
yes they are, am able to run the exact same query just fine on dBeaver on the same db server and schema.
i tried app.crosstab() and crosstab() - both did not work.
tried again with app.crosstab it worked. not sure what i was doing wrong last night.
