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 vote164 views1 answer
Sql server select top 2 of each group
SQL
0 vote194 views1 answer
Mysql disable triggers
SQL
0 vote201 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote169 views1 answer
Oracle step procedure
SQL
0 vote227 views1 answer
Hierarchal database table
SQL
3 votes194 views5 answers
Foreign keys
SQL
0 vote184 views1 answer
Oracle sql add column auto generated value
SQL
-1 vote179 views1 answer
Get id from just inserted row mysql server python
SQL
2 votes179 views2 answers
Mysql show table column comments sql
SQL
0 vote174 views2 answers
Oracle sql for each row
SQL