QUERY JPQL

select la 
  from lancamento la 
 where (:descricao is null or descricao like %:descricao%) 
   and (:dataDe is null or dataVencimento >= :dataDe) 
   and (:dataAte is null or dataVencimento <= :dataAte)

Source: app.algaworks.com

Similar codes

0 vote356 views1 answer
Sql alchemy escape ; in insert statement
SQL
1 vote358 views1 answer
Oracle stop
SQL
1 vote329 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote361 views2 answers
Nosqlbooster query other collection
SQL
1 vote337 views1 answer
Sql server locks
SQL
2 votes321 views1 answer
Mysql sysdate
SQL
0 vote367 views1 answer
Excel export from sql using python
SQL
0 vote333 views1 answer
Sql query for displaying age from oldest to youngest
SQL
2 votes349 views1 answer
How to insert string variable into sqlite database
SQL
3 votes364 views1 answer
Postgres kill running query
SQL