• Maven Java version to 18
• Removed the use of mysql from this demo application, instead it uses in memory H2 database now
• Sample data is in resources/data.sql file
• Spring Boot to 2.7.4 version
• Angular to 14.2.0 version
• Primeng to 14.1.2 version

• Processing of the boolean type filter
• Changes in the test database and the test java model

fix

• Angular to 13.3.0 version
• Primeng to 13.4.0 version

• Processing of the boolean type filter
• Changes in the test database and the test java model

• Primeng 11 came with many changes in the table component : a date filter was added and the text filter can now have multiple rules, this version take account of those changes
• This project is compatible with the table component of both v10 and v11 of Primeng

PrimeNg tables have a 'lazy' mode when displaying data, it sends all the requests of paging, sorting and filtering to the server to be processed. The goal of the this project is to make this server side processing the most generic possible (Spring boot).

• The 'ng' folder contains the sample front-end Angular 11 project
• The Spring Boot project is a minimal showcase and can be used as a base for other projects, it contains : a sample entity, dao, controller and service and two core classes responsible of building queries

The idea is to make an utility class that parse and convert a PrimeNg json request to a paging and sorting query and build an RSQL query for the columns and general filters, this rsql query will then converted to Jpa specification with rsql-jpa-specification and executed against the dao.

The two most important java classes in this project are :

• org.nd.primeng.search.PrimengRequestData : a bean to hold the data parsed from the PrimeNg table request
• org.nd.primeng.search.SearchBuilder : responsible for parsing the PrimeNg table json request, generating the paging and sorting jpa query and building an Rsql query from the filters
• Please refer to the class org.nd.primeng.services.UserService for an example to how to use those classes
• Your repository class needs to extends JpaSpecificationExecutor and QuerydslPredicateExecutor, please refer to UsersDao class for an example

This project uses rsql-jpa-specification to work, please refer to its documentation to see how the intial setup is done.

• The simplest form : you can use the generated specification with your repository, example :

return usersRepository.findAll((Specification<User>) queries.getSpec(), queries.getPageQuery());

• Advanced Method : if you need to add a condition to the RSQL query before execution you can use this form, example :

customQuery = queries.getRsqlQuery() + " and name=='John'"
return usersRepository.findAll(RSQLJPASupport.<User>toSpecification(customQuery).and(RSQLJPASupport.toSort(queries.getSortQuery())), queries.getPageQuery());

In order to properly filter against date columns, you need to do two things :

• Never use java.util.Date or any other java date types as type in your entity classes, use only java.time.LocalDateTime

• You need to properly setup your timezone in the jvm with the parameter -Duser.timezone, example :

  -Duser.timezone=Europe/Paris

• Create a database in mysql with name : app_db
• Execute the sample data sql file /db/sample-data.sql againt the database
• Set your timezone in pom.xml in order to the date filtering to work properly :

<configuration>
	    <jvmArguments>
		 -Duser.timezone=Europe/Paris
	 </jvmArguments>
</configuration>

• Run the Spring boot project
• Run the Angular 11 project