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 vote318 views2 answers
Sql query in dax power bi
SQL
1 vote316 views1 answer
Float precision in psql
SQL
0 vote308 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote340 views1 answer
Is not numeric sql
SQL
0 vote302 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote294 views1 answer
Oracle execute immediate quotes
SQL
8 votes425 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote322 views2 answers
How covert into int in maria db
SQL
15 votes329 views5 answers
Show tables in oracle
SQL
42 votes393 views6 answers
Install beautifulsoup
SQL