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

20 votes187 views6 answers
Creating a table in sql
SQL
1 vote163 views1 answer
Mysql random limit 1
SQL
2 votes176 views1 answer
Postgresql create schema in specific database
SQL
1 vote168 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote230 views1 answer
Get first monday of month sql
SQL
0 vote162 views1 answer
Mysql update sum same table
SQL
0 vote158 views1 answer
Mysql earlier than date
SQL
0 vote174 views1 answer
Import sql in postgresql
SQL
4 votes204 views5 answers
Get last query in codeigniter 4
SQL
8 votes202 views1 answer
Racle create auto increment column
SQL