Using views in CriteriaQuery [message #719286] |
Fri, 26 August 2011 15:33 |
Chris Oman Messages: 2 Registered: August 2011 |
Junior Member |
|
|
The situation: web form that allows the user to fill out information to be used in a query.
Technologies: EclipseLink, H2, Glassfish
Problem: I have gotten nearly everything to work exactly as I want with the CriteriaQuery. The one problem I have remaining is that I want the user to also be allowed to type in a keyword and use the H2 'FT_SEARCH_DATA()' fulltext search function. I couldn't figure out how to use functions in the where portion of the CriteriaQuery, so I have created a view to do essentially the same thing as that function.
I am still having trouble figuring out how to include that view as a joined table in the CriteriaQuery. Has anyone done anything like this before? Can it be done?
Thanks,
Chris
[Updated on: Fri, 26 August 2011 15:34] Report message to a moderator
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.12532 seconds