grocery-crud icon indicating copy to clipboard operation
grocery-crud copied to clipboard

flexigrid/bootstrap theme -> WHERE clause AND (search term_n OR search term_n+1...etc.), not OR

Open Pimnr47 opened this issue 7 years ago • 1 comments

Modification of set_ajax_list_queries function in grocery_CRUD_Model_Driver to ensure that the WHERE clause set in the controller is taken as an AND condition, in combination with the query terms flexigrid/bootstrap theme sends as ajax request.

It is to fix the unexpected behaviour that, when you set the where clause in the controller (for example to only show records for a specific user) and enter some search terms in the flexigrid/bootstrap theme table, records are shown outside of the WHERE clause.

I believe this modification results is the behaviour that is more expected of grocery crud.

Pimnr47 avatar Jul 09 '17 09:07 Pimnr47

code is outdated but this problem is happened in bootstrap theme v3, yes! good solution but still late! :<

mckaygerhard avatar Sep 01 '21 16:09 mckaygerhard