Before I answer your questions, you need to know sigma ajax grid support client side & server side search. You have to do a server search to gain what you want.
1) you need to do get filter info at server side and translate it into sql, say select * from table1 where A like 'abc%' or B like 'abc%'
2) Also you need to get page info and do a limit by sql
thanks steven, to question 2, I can set remotepage=false and get all data into grid,
to question 1, I hope to know how to do a server filter(or how to set) in sigma grid, there is no demo for it,
another question : if I do dynamic search in server's side, how to page data in server's side at meantime.
thanks.