With application based on seam-gen, the MyEntityList feature is based on single table. I guess it is possible to make it work with multiple tables. wondering anyone can help me out? Table Associations Client--->Contacts--->Addresses Clients--->Applications ---> represents one-to-many I get errors like, even though all my search columns are text: 11:39:16,776 ERROR [DebugPageHandler] redirecting to debug page java.lang.NumberFormatException: For input string: "username" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) at java.lang.Integer.parseInt(Integer.java:447) Say would like to search by: client.username, contact.surname, address.postcode, application.status | @Name("clientList") | public class ClientList extends EntityQuery { | | private static final String[] RESTRICTIONS = { | "lower(client.username) like concat('%',lower(#{clientList.client.username}),'%')", | "lower(contact.surname) like concat('%',lower(#{clientList.contact.surname}),'%')", | "lower(address.postcode) like concat('%',lower(#{clientList.address.postcode}),'%')", | "lower(application.status) like concat('%',lower(#{clientList.application.status}),'%')", | }; | | private Client client = new Client(); | private Contact contact = new Contact(); | private Address address = new Address(); | pircate Application application = new Application(); | | @Override | public String getEjbql() { | | return "select client.username, contact.surname, address.postcode, application.status " + | "from Client client inner join client.contacts contact....????????????????"; | } | | public Client getClient() { | return client; | } | | public Contact getContact() { | return contact; | } | | public Address getAddress() { | return address; | } | | public Application getApplication() { | return application; | } | | ... | | } | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100486#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...