DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

MJOIN and multiselect filtering issue

MJOIN and multiselect filtering issue

CapamaniaCapamania Posts: 233Questions: 81Answers: 5
edited January 2017 in Editor

Hi Allan ... happy New Year! :smile:

I'm still having the issue with the multiselect fitering on the MJOIN table. (Old post: https://datatables.net/forums/discussion/39606/mjoin-and-multiselect-filtering-issue). I've sent you a private message prior to the holidays with the details and the link. By any chance, how can I solve this? Do I need to change sth with the mysql table setup maybe?

Many thanks

Answers

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin

    Sorry about the delay - I'll reply back to your PM shortly.

    Allan

  • CapamaniaCapamania Posts: 233Questions: 81Answers: 5

    Hi Allan ... did you have a chance to look at the "debugSql" information the array is showing now? Please let me know if I should provide you more information.

    Many thanks

  • CapamaniaCapamania Posts: 233Questions: 81Answers: 5

    Hi Allan ... is it not possible to filter on a MJOIN table? Regards

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin

    is it not possible to filter on a MJOIN table?

    Not with server-side processing enabled. The reason for that is that the Mjoin is not part of the main query, so it would be extremely expensive to implement that (in terms of processing cost / latency). The Mjoin information comes from a separate query.

    With client-side processing, then yes, it should just work automatically.

    Sorry I haven't replied to your PM yet. I'll get to it soon!

    Allan

This discussion has been closed.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.