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

5 votes356 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote361 views1 answer
Describe table in sql
SQL
0 vote356 views1 answer
How to execute stored output to csv files
SQL
1 vote351 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote338 views1 answer
Automate mysql cli query
SQL
0 vote366 views1 answer
SQL authentication error
SQL
0 vote427 views1 answer
Generate a random otp in sql server
SQL
0 vote396 views1 answer
Postgresql find biggest table
SQL
-1 vote361 views1 answer
Mac mysql workbench console
SQL
31 votes341 views3 answers
Sql count
SQL