search data

Data Search Form and page linking

I am making a form with three search fields and a Search button. The result of this search shall be displayed on this same page below search criteria in a table.

I have made that page. I have also made custom query which shall get fired when the Search button will be pressed.

SELECT e
FROM Candidate e
WHERE e.ssn = :ssn
OR e.passport = :passport
OR e.name like :name
ORDER BY e.persistenceId ASC

The query needs to search record for any of the data as filled in the form

Notifications