Posted: Wed Aug 22, 2007 6:17 pm
The tablefilter is indeed the way to go in SaaS solutions where the chosen SaaS implementation is one where the data of all customers is stored in the same database and tables, separated only by an "ownerid" column.
The tablefilter adds the additional where-clause to all SQL statements generated by Servoy. So, if you use your own SQl statements in your solution to get data, you need to take care of adding the additional where-clause yourself.
Same goes for Jasper Reports: You put the queries into the report, not Servoy (and the reports execute Server side, so not aware of what has been set in the Client).
Paul
The tablefilter adds the additional where-clause to all SQL statements generated by Servoy. So, if you use your own SQl statements in your solution to get data, you need to take care of adding the additional where-clause yourself.
Same goes for Jasper Reports: You put the queries into the report, not Servoy (and the reports execute Server side, so not aware of what has been set in the Client).
Paul