I have an application in which I need to allow end users to create adhoc reports by defining their parameters using some type of wizard, the process of which will be something like this:
1) User selects the table(s) he wants to query (eg person, project, activities)
2) defines the list of fields he requires (eg name, email, projects, activity, activity info)
3) supplies the filter criteria for the records to return (eg Person name, ongoing activities)
I am using hibernate with a postgres database with over 100 tables. Of course, I cannot allow the user to select any of these tables, since they do not make any sense. But about 10 main tables (for example, above).
I need an advice:
- Is it possible and how to dynamically determine the joins and relationships between these tables and their other relationships?
- If not, (or too complicated), what would be the best way to predefine these connections and database paths, and then allow users to only parameterize filters?
- Get data from more than one hibernation object, and then let the user select the fields that he wants.
I really appreciate all the feedback, if I do not explain the necessary information, please write.
source
share