Searching with one-to-many joined tables

Khalid Teli

Hi ,
I was following this example https://editor.datatables.net/examples/advanced/joinArray.html

Is it possible to search the permission column whenserverSide : true is enabled. Currently, it is not able to search when serverSide is enabled.

Thank you

allan

Currently no - sorry. The issue is that the Mjoin implementation at the server-side uses a second query to get the information from the database. That negates the ability to use the SQL WHERE statement across a whole single query.

At the moment if you need search abilities on the Mjoin labels, you'd need to use client-side processing.

Regards,
Allan

ameji012

I'm uber late to this but if you create a view within your database to the table in question and left join this to your editor then reference this within the js for the datatable instead of the mjoined column the search will work. Hope it helps. Allen it would be a nice to have feature if we could search serverside joined.

Here is Allans sugestion which helped.

https://datatables.net/forums/discussion/comment/202360#Comment_202360

allan

Good to hear you've got a solution.

We don't currently plan to add this ability to Editor, as it would be too prescriptive on the SQL schema - it is possible to do, but we would require certain database patterns which is something I'm keen to avoid in Editor.

Our CloudTables software does have this ability though

Regards,
Allan