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.
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