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 vote311 views1 answer
SQL server datetime compare
SQL
0 vote285 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
22 votes305 views4 answers
Date format mysql
SQL
-1 vote281 views1 answer
Sql oracle take only last results
SQL
0 vote270 views1 answer
Uuid sqlalcomany
SQL
0 vote273 views1 answer
Php delete database
SQL
0 vote276 views1 answer
Mysql foreach insert
SQL
0 vote267 views1 answer
Default value false mysql
SQL
6 votes273 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote286 views1 answer
Sql server convert to guid
SQL