New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Filtros tipo OR #6

Open

0x3333 opened this issue Jun 2, 2015 · 1 comment

0x3333 commented Jun 2, 2015

Hoje é possível pesquisar filtros OR apenas com o operador Equals, quando é preciso fazer um Like com diversos ORs isso não é possível.

Ex.:

select p from Person p
where (p.name LIKE '%Joseph%' OR p.lastName LIKE '%Samarc%') AND (p.name LIKE '%Hebert%' OR p.lastName LIKE '%Antoni%')

landaida commented Aug 19, 2016

Lo mismo pasa cuando quiero usar "is null" Ejemplo: Hello, after reading this example:

Ejemplo de la página:
select s from Song s where (s.totalDownloads = 20 or s.weight = 10.00) and (s.price = 20.00 or s.type = :type)

Lo que yo necesito:
(s.price = 20.00 or s.type is null), how to make this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment