The same issue occurs with the search functionality as well. I managed to get it work by changing line 105 of assets/grocery_crud/themes/flexigrid/views/list_template.php, adding the code in bold. <option value="<?php echo $this->get_table().".".$column->field_name?>">… However this would reveal …

I have found the joins generated, and the comment above… Let me suggest supplementing the documentation for where() API at where | Grocery CRUD, a Codeigniter CRUD Due to the extra joins the API does not exactly work like codeigniter’s where: specifying table alias is required if the joins make th…