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 vote126 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote121 views2 answers
Postgresql create role
SQL
22 votes131 views4 answers
Show list of users in mysql
SQL
9 votes138 views4 answers
How to alter table column name in mysql
SQL
0 vote134 views1 answer
Drop-toys-table
SQL
9 votes126 views4 answers
How to remove duplicate in sql
SQL
-1 vote130 views3 answers
Create temp table in sql
SQL
0 vote134 views1 answer
How to find columns with null values in sql
SQL
0 vote225 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
24 votes150 views4 answers
Mysql datetime
SQL