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 vote105 views1 answer
C# get sql min date
SQL
0 vote57 views1 answer
Kannst du deine finger trainieren
SQL
0 vote96 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote96 views1 answer
Mysql best tutorial for beginners
SQL
1 vote116 views1 answer
Mysql current running queries
SQL
0 vote116 views1 answer
How to combine first and last nae into one columb sql
SQL
3 votes140 views2 answers
@sqlresultsetmapping
SQL
0 vote78 views0 answer
SQL
-1 vote103 views1 answer
Mysql #1064 error
SQL
0 vote165 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL