DataTablesSpecification does not handle collection members about spring-data-jpa-datatables HOT 2 CLOSED

Hi! That is a great question. The basic Specification is indeed limited to class attributes or @manytoone relationships. The SQL counterpart are:

• "attribute" => WHERE table.attribute = :value
• "relatedEntity.attribute" => JOIN relatedEntity WHERE relatedEntity.attribute = :value

That is the very basic usage. For more complex needs, my opinion is that Datatables (and thus this implementation) has absolutly no clue about what the user wants to do. So it lets him make whatever he wants (handling @manytomany relationships, using 'BETWEEN' clause...) through the following method: public DataTablesOutput<T> findAll(DataTablesInput input, Specification<T> additionalSpecification).

With this, the user is able to either pass directly the input object mapped from the request (the basic usage) or process this input to create an additionalSpecification according to his needs. Please see this example: https://github.com/darrachequesne/demo-spring-datatables/blob/master/src/main/java/demo/controller/UserRestController.java#L46

In that example, the "classic" filter value is cleared, and a custom Specification is built from the latter. I think it should cover most use-cases, but please tell me if I'm wrong.

from spring-data-jpa-datatables.

Hi Damien,
Thanks for your insights. Your design condiserations are straightforward and fully serve the purpose. As far as I can see, the Specification passed as parameter to findAll can not be written in a way that it is capable to handle collection attributes. Finally, I ended up rewriting your DataTablesRepositoryImpl and wire the required specification in its public DataTablesOutput<T> findAll(DataTablesInput input, Specification<T> additionalSpecification) and thus gain control over related SetAttributes via Subquerys . The datatables now work fine and serverside processing with spring-data-jpa-datatables reduces the time for pages to get displayed a lot. Again, thanks for sharing!
Tom

from spring-data-jpa-datatables.