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 vote263 views2 answers
Mysql updating multiple column values from array variable
SQL
-1 vote275 views1 answer
Round up and down sql
SQL
1 vote275 views1 answer
Oracle drop job if exists
SQL
0 vote259 views1 answer
Select count postgres double row count > 1
SQL
2 votes286 views1 answer
Revokeprivileges mysql
SQL
0 vote294 views2 answers
Check if sql temp table exists
SQL
0 vote272 views3 answers
Remove folders from remote git
SQL
0 vote302 views1 answer
Combine 2 columns search query mysql
SQL
3 votes274 views1 answer
Oracle drop user
SQL
0 vote355 views1 answer
Compare strings lexicographically in sql
SQL