Dynamic Column Filtering with Hibernate for CRMs

[Sebastian Janisch]

Hey :-)

For the filtering of customer data in a CRM System I was wondering if there are any well established approaches or libraries available.

The concrete requirements are pretty straight forward.

On the web-frontend, a table shows a list of basic information of customers, such as name, phone, email etc. Pretty much a one-to-one display of the database table.

All available columns shall have the functionality to filter on them, e.g. restrict the name to "John Doe" and the zip code to "91423".

How would that on the other end be translated into a hibernate query. I could manually translate it using the Criteria or Filter API, but that seems a cumbersome thing to do.

Looking forward to hearing your advice

[Bill Gorder]

Sounds like you are looking for a data table like jqGrid

Below is a tutorial on using it with Spring data-jpa. Even if you are not using that particular framework the concepts are the same using vanilla JPA or Hibernate. It might give you some ideas.
http://krams915.blogspot.com/2012/01/spring-mvc-31-jqgrid-and-spring-data_1887.html