|Using views in CriteriaQuery [message #719286]
||Fri, 26 August 2011 15:33
| Chris Oman
Registered: August 2011
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?
[Updated on: Fri, 26 August 2011 15:34]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.17358 seconds