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 vote157 views1 answer
Mysql terminal list table
SQL
0 vote146 views2 answers
Mysql regexp match word
SQL
0 vote160 views1 answer
What is initial catalog in sql connection string
SQL
4 votes166 views1 answer
Create column mysql terminal
SQL
0 vote174 views1 answer
Python sqlalchemy connection show server
SQL
0 vote147 views1 answer
Mysql export and import
SQL
6 votes160 views3 answers
Mysql first day of year
SQL
20 votes172 views4 answers
Sql count if
SQL
5 votes159 views1 answer
Mysql count lines
SQL
0 vote224 views3 answers
How to find all role in mysql
SQL