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 vote193 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
1 vote184 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote253 views1 answer
Sql pivot table
SQL
0 vote182 views1 answer
Oracle free up space in tablespace
SQL
10 votes202 views4 answers
How to alter table name in mysql
SQL
9 votes178 views1 answer
Mysql check date range
SQL
0 vote210 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote310 views1 answer
Sql insert exemplo
SQL
3 votes211 views1 answer
Where id is in list sql
SQL
0 vote197 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL