Important Notice - Forums is archived
To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
addContainerFilter not working
When I run the following code the result set is not filtered.
When I look at the query sent to SQLServer the where statement is not added.
What do I wrong?
With kind regards,
Chris Gerrist
JDBCConnectionPool mpool = null;
SQLContainer container = null;
try {
mpool = new SimpleJDBCConnectionPool("net.sourceforge.jtds.jdbc.Driver", "jdbc:jtds:sqlserver://10.0.1.150/ITK_LN_Scheduler", "sa", "sa", 2, 5);
} catch (SQLException e1) {
e1.printStackTrace();
}
TableQuery tq = new TableQuery("ITK_JOBACTION", mpool);
tq.setVersionColumn("OPTLOCK");
FreeformQuery fquery = new FreeformQuery(
"SELECT JOBACTIONID, JOBID, NAME, CLASSSRCNAME, CLASSDSTNAME, JOBSTATUS, JOBACTIONSTART, ELAPSEDTIME FROM ITK_JOBACTION ORDER BY JOBACTIONID DESC", pool, "JOBACTIONID");
try {
container = new SQLContainer(fquery);
} catch (SQLException e) {
e.printStackTrace();
}
container.addContainerFilter(new Like("JOBID", "17"));
It's limitation of FreeformQuery.
You need to implement FreeformQueryDelegate or FreeformStatementDelegate.
https://vaadin.com/book/-/page/sqlcontainer.freeform.html
Example of implementing FreeformStatementDelegate:
http://dev.vaadin.com/svn/addons/SQLContainer/branches/new-filter-api/demo/src/com/vaadin/addon/sqlcontainer/demo/DemoFreeformQueryDelegate.java