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

1 vote213 views1 answer
Mysql select for update ejemplo
SQL
0 vote194 views1 answer
How to install sql in anaconda
SQL
0 vote224 views1 answer
Oracle date summer time
SQL
0 vote190 views1 answer
How to count with except in psql
SQL
0 vote336 views1 answer
Android sqlite add column if not exists
SQL
2 votes237 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote234 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
18 votes234 views6 answers
Laravel form validation
SQL
7 votes231 views3 answers
Sql server check if temp table exists
SQL
1 vote222 views2 answers
One to one and one to many relationship
SQL