Not able to filter by typing in the filterbar For the FilterTable addon

[Vipin1 (Vipin Lodhi)]

HI

I am using the SQLContainer for reteriving the data from the database.

Following is the code snippets…

private static final String VISIBLE_COLS ={“id”,“name”,“lastname”};

pool = new SimpleJDBCConnectionPool(“com.sybase.jdbc3.jdbc.SybDriver”, “url”, “username”, “password”);
FreeformQuery tq = new FreeformQuery(“select id,name,lastname from name”,pool,“id”);
SQLContainer container = new SQLContainer(tq);

FilterTable fundTable = new FilterTable();

fundTable.setImmediate(true);
fundTable.setSizeFull();
fundTable.setContainerDataSource(container);
fundTable.setVisibleColumns(VISIBLE_COLS);
fundTable.setFilterBarVisible(true);
fundTable.setColumnCollapsingAllowed(true);
fundTable.setColumnReorderingAllowed(true);

as i am not able to filter the data on typing the character in the filter bar.

Please suggest the solution or please provide the code of “online demo” of FilterTable u have posted.

Thx.

[Teppo (Teppo Kurki)]

@Vipin Lodhi

pool = new SimpleJDBCConnectionPool(“com.sybase.jdbc3.jdbc.SybDriver”, “url”, “username”, “password”);
FreeformQuery tq = new FreeformQuery(“select id,name,lastname from name”,pool,“id”);
SQLContainer container = new SQLContainer(tq);

Just noticed that you do not set a FreeformQueryDelegate to your FreeformQuery. You are required to implement that interface in order to make filtering, ordering and/or storing of rows work with a freeform query.

Please see the interface com.vaadin.data.util.sqlcontainer.query.FreeformQueryDelegate and
this chapter
in the book (and the related example) for more information.