DataTables Search?

[nanawel]

It seems searching using DataTables "Search" field is not supported with MongoDB documents. Am I right? Currently on my application, using this field immediately empties the table.

I've found this which might indicate so: https://github.com/mmucklo/DtcGridBundle/blob/6b7f620d5a60d20449700fa8e786adf27d79e4b0/Grid/Source/DocumentGridSource.php#L72

I suppose the alternative would be to use filter/sort/search on the client side using the appropriate config directive, but it's not possible with large collections.

[mmucklo]

@nanawel,

I can look into adding regex if you're still interested.

[nanawel]

Hi @mmucklo. Thanks for your proposal. But in the meantime I had to leave MongoDB and switch to SQLite as I encountered too many problems and limitations with it. I've turned to https://github.com/omines/datatables-bundle to handle the grids and it's working quite well.