I have the below select SQL query SELECT * FROM data_entity WHERE agreement_number='9999' AND use_type='xxxx' AND end_date IS NOT NULL AND end_date <= '2022-05-03'::date OR (rib='1111111' AND iban='22222222'); I want to convert it to query using hibernate search, i tried with the below query, bu…

Looks like this was crossposted from stack overflow: https://stackoverflow.com/questions/63374039/hibernate-search-cconvert-sql-to-lucene-query/63446326#63446326 Closing this topic and answering there.

Hibernate search - convert sql to lucene query - #3 by yrodiere - Hibernate Search

Topic		Replies	Views	Activity
Combine Hibernate Search query with Lucene query Hibernate Search	3	805	February 1, 2021
Hibernate Search 6 : Cannot use 'predicate:simple-query-string' on field Hibernate Search	8	1248	March 8, 2022
Could Hibernate Search do search like SQL"select * FROM TABLE WHERE A = B"? Hibernate Search	2	683	September 28, 2018
Hibernate little queries when using date Hibernate ORM	0	340	August 4, 2020
How to create conditions in Hibernate Search Queries Hibernate Search	1	840	August 6, 2018