File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Dynamic Column Filtering with Hibernate for CRMs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Dynamic Column Filtering with Hibernate for CRMs" Watch "Dynamic Column Filtering with Hibernate for CRMs" New topic

Dynamic Column Filtering with Hibernate for CRMs

Sebastian Janisch
Ranch Hand

Joined: Feb 23, 2009
Posts: 1183
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

JDBCSupport - An easy to use, light-weight JDBC framework -
Bill Gorder

Joined: Mar 07, 2010
Posts: 1682

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.

[How To Ask Questions][Read before you PM me]
I agree. Here's the link:
subject: Dynamic Column Filtering with Hibernate for CRMs
It's not a secret anymore!