I am running Servoy 7.4.1 on Mac and Linux and in my solution I have a global table filter set on organisation_id for all tables and this works with no problems when using found sets. I now have some code that uses the query builder to generate custom queries that reference tables with the global table filter applied and I am finding that the table filter seems to be ignored.
I am using a QBSelect object to build my custom query and then running databaseManager.getDataSetByQuery(qbSelectObject, -1) to populate my dataset. The Wiki implies that using this particular version of the getDataSetByQuery should honour the table filter but my experience shows that it is not.
There are only two ways to circumvent a table filter:
# by issuing a custom SQL query String through the getDataSetByQuery method of the databaseManager API. (Note: the version of getDataSetByQuery that takes a QueryBuilder object as first parameter DOES take into account applicable TableFilters
The Performance Data section of the Servoy Admin page shows the query without any reference to the fields to be filtered. Am I doing something wrong or should I report this as a bug?
Thanks
Steve