File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
Dynamic Column Filtering with Hibernate for CRMs
Joined: Feb 23, 2009
Sep 04, 2012 09:25:22
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
An easy to use, light-weight JDBC framework
Joined: Mar 07, 2010
Sep 04, 2012 11:43:04
Sounds like you are looking for a data table like
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
subject: Dynamic Column Filtering with Hibernate for CRMs
JSF 1.1 - Multiple instance with multiple faces-config - Oracle ADF and Apache Trinidad
HibernateTools Generating Wrong Code
struts 2 validation and prevent double submit
Hibernate object states and lifecycle?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014