datatables search capability about spring-data-jpa-datatables HOT 6 CLOSED

Damiens Spring Data JPA datatables work great!
Especially if one links jquery.spring-friendly.js properly in the containing HTML as described e.g. here 😄

from spring-data-jpa-datatables.

Hey Damien @darrachequesne,

it's work like a charm now! thanks a lot for your help!!

from spring-data-jpa-datatables.

That exception javax.persistence.RollbackException is indeed not really helpful.

Yes, the search feature should work, either by global search search[value] or per-column search columns[i][search][value] in the payload sent to the server (described there).

Note: the default input field on the right of the table should trigger a global search.

I'm afraid I'll need a bit more to help you:

• the payload sent to the server
• the definition of the DataTable itself on the client-side, if possible

If you don't want to/can't share this here, maybe could you contact me by mail?

Cheers!

from spring-data-jpa-datatables.

Great news 😄 !

I was wondering whether your columns were @OneToMany or @ManyToMany relationships, since it involves a bit more work (the data should be something like linkedentity.attribute, see example there), but if it works for you, that's great!

from spring-data-jpa-datatables.

Great news 😄 !

I was wondering whether your columns were @OneToMany or @ManyToMany relationships, since it involves a bit more work (the data should be something like linkedentity.attribute, see example there), but if it works for you, that's great!

Hey Damien,

it seems the link you've given is not working now. can you provide a new link? since I'm working with @OneToMany and @ManyToMany relationship now with data table

Thanks

from spring-data-jpa-datatables.

@diorndk you are right!

The example project is here: https://github.com/darrachequesne/spring-data-jpa-datatables-sample

And the lines in question: https://github.com/darrachequesne/spring-data-jpa-datatables-sample/blob/f9a10c2d252ac0ecae978fe17f66ebcef305d82d/src/main/resources/static/index.html#L82-L85

from spring-data-jpa-datatables.