w2ui grid search

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... :)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemant Panchal11y ago
I have already tried this,,,by splitting string into an array... than applying search in w2ui.js but it takes last word as search text. So filter is happenning as per last word in search string. If you are using w2ui.js kindly check its js file.

thanks .... :) :)
0
Prem Anandh J11y ago
Hi Hemant,
Try this,
1. put the search string into array string.
2. count the number of (substring)words in searching string
3. use or loop for dynamic query. add the condition with substring value
-------------------------------------------------------------------
If you find anything useful please accept my answer
0