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:

DtcGridBundle/Grid/Source/DocumentGridSource.php

Line 72 in 6b7f620

// @TODO - maybe allow pattern searches some day: new \MongoRegex('/.*'.$value.'.*/')

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.