Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Dynamic Column Filtering with Hibernate for CRMs

 
Sebastian Janisch
Ranch Hand
Posts: 1183
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic