SS
Asked
I'm looking at controllers/Reports.php and as I'm not familiar with datatables, I have to ask: How can change the query so it searches in both sale_items.product_name AND sale_items.details?
- MSAnsweredHello,
You can check the `getsales` method. The product is search with
```php
if($product) { $this->datatables->like('sale_items.product_name', $product, 'both'); }
```
You can add `or_like()` to search other columns on the table.
Thank you - SSAnsweredWell, I thought I tried that, but I must have typo'd something. Works now. Thanks!
- MSAnsweredI am glad to know that you have manage to modify it as you need. Thanks for updating
- Login to Reply