I need to implement a dynamic query logic, in the DB using JPQL, and I have 4 filters:
1 - PROJECT COORDINATOR
2 - SERVICE PROVIDER
3 - DATE START OF THE PROJECT
4 - FINAL DATE OF THE PROJECT
Any of the fields can be combined together, that is, COORDINATOR and INITIAL DATE, SUPPLIER and INITIAL DATE can be selected, and so on ...
The tables are being managed by their Entities:
ProjectEntity contains the attribute "coordinator"
PlanEntityEntity contains the attribute "provider"
EntregaEntity contains the attribute "datainicial" and "datafinal".
I tried to implement Criteria (uaihebert, easycriteria, criteriabuilder and etc), but I did not have much success, if anyone has any indication, even initial wue, I'll be grateful.