append Postgres Full Text Search expression after having CriteriaQuery [message #1272703] |
Tue, 18 March 2014 14:44 |
Clovis Wichoski Messages: 7 Registered: March 2012 |
Junior Member |
|
|
Hi,
I have a scenario where the user create some filters using CriteriaQuery, but one of that filter was a free search field, I wish to get the EclipseLink generated SQL and append the a String on that SQL, but the DatabaseQuery returns null from CriteriaQuery, here is the algorithm idea:
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery cq = cb.createQuery();
//populates cq suppressed content
TypedQuery q = em.createQuery(cq);
String generatedSQL = q.unwrap(JpaQuery.class).getDatabaseQuery().getSQLString();
String nativeSQL = generatedSQL + " AND buscaLivre @@ to_tsquery('ELX')";
ps: buscaLivre is the field that allow the full text search.
This dont works as the content of generatedSQL is null then the nativeSQL string get the value "null AND buscaLivre @@ to_tsquery('ELX')".
I tried to find some way to inject this expression on where part of criteria, but dont found a native() method, if that exists that would be great, but as dont exists I tried to concat SQL strings, any way to get that SQL? anyone have a better approach for that?
best regards
Clóvis
|
|
|
|
Powered by
FUDForum. Page generated in 0.03131 seconds