darrachequesne / spring-data-jpa-datatables

Spring Data JPA extension to work with the great jQuery plugin DataTables (https://datatables.net/)
Apache License 2.0
447 stars 173 forks source link

Dose search filter support regular search? #43

Closed njwangchuan closed 7 years ago

njwangchuan commented 7 years ago

The origin datatables support regular search in column.search() method, but it seems not working with Datatables and will return an empty list with search. I noticed that the README file says filter with String Type will translate to "like'%%'",does it means the lib is not support regex search yet?

Thanks

darrachequesne commented 7 years ago

Hi! Please see my response here.

tl;dr: the regex flag is not supported because JPA does not support regexp matching.

njwangchuan commented 7 years ago

@darrachequesne thank you very much.I just want to do exactly search and i find a solution with 'in' filters

darrachequesne commented 7 years ago

Great! Is there anything left? Else, could you please close the issue?