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 vote356 views1 answer
Sql convert unix time to date
SQL
1 vote324 views1 answer
Set statistics on in ssms
SQL
4 votes336 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote322 views1 answer
Mysql show foreign keys column
SQL
0 vote402 views2 answers
Remove mysql workbench ubuntu
SQL
4 votes341 views1 answer
Mysql copy table with new name
SQL
0 vote392 views1 answer
Sql to excel pgadmin
SQL
6 votes372 views3 answers
How to delete table sqlite
SQL
0 vote353 views1 answer
Mysql uuid
SQL
0 vote366 views1 answer
Show specific events on mysql
SQL