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 vote191 views1 answer
Mysql Install Ubuntu with native password
SQL
4 votes152 views1 answer
Sql list users and roles
SQL
3 votes169 views1 answer
Sql timestamp to date
SQL
0 vote225 views2 answers
Sql unique
SQL
2 votes183 views1 answer
Oracle to_char number format percentage
SQL
0 vote171 views1 answer
Mysql select last 15 minutes
SQL
0 vote180 views1 answer
Plsql find location of procedure
SQL
0 vote178 views1 answer
Sqlalchemy query return only n results
SQL
0 vote186 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote189 views1 answer
Oracle sql count occurrences of value in column
SQL