Hi;
A problem that I’ve found is that TIBCO Jasper Studio can’t fetch data from the cmdbuild database if multitenant configuration is enabled, because of the postgres Row Level Security.
I came across with a solution that I would like to share with everyone:
In the JDBC connection you can add session attributes (used in the RLS policy), so the connection string should look like this:
jdbc:postgresql://server:port/database?options=-c%20cmdbuild.user_tenants={}%20-c%20cmdbuild.ignore_tenant_policies=true
Cheers