w2ui grid search

Question

Hello all, I am working on w2ui grid search, I want to have a multiple column search in same textbox. Search text is separated by space. 

Suppose my data is

"records": [

{ "recid": 1, "fname": "John", "lname": "Doe", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 2, "fname": "John", "lname": "Motzart", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 3, "fname": "John", "lname": "Franson", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 4, "fname": "Susan", "lname": "Franson", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 5, "fname": "Kelly", "lname": "Franson", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 6, "fname": "Francis", "lname": "Franson", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 7, "fname": "Mark", "lname": "Welldo", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 8, "fname": "Thomas", "lname": "Bahh", "email": "[email protected]", "sdate": "4/3/2012" },

{ "recid": 9, "fname": "Sergei", "lname": "Rachmaninov", "email": "[email protected]", "sdate": "4/3/2012" }

]

 

now in w2ui grid search box I am searching "John"

then it should display  1,2,3 records

 

thn I am searching "john fran" 

then it should only display  3rd record. 

 

NOTE: Search text is dynamic it is not specific to particular columns. 

 

I want exact search like in datatables.net

 

It makes AND condition based on search sequences.

 

Please help thanks... :)