Dolibarr: Feature Request: Search in extrafields

Created on 8 Sep 2015 · 4Comments · Source: Dolibarr/dolibarr

Extrafields can´t be searched. This is a downside for handling customer specific requirements such as drawing numbers with products etc.

Feature request Issue Stale (automatic label) Priority Low

Source

low5

Most helpful comment

here is how i did with dolibarr 4.0.3

caution !! : it is not a good pratice to hard code in the dolibarr core

```diff --git a/www/product/list.php b/www/product/list.php
index c95156b..1c3e608 100644
--- a/www/product/list.php
+++ b/www/product/list.php
@@ -118,6 +118,9 @@ $fieldstosearchall = array(
'p.label'=>"ProductLabel",
'p.description'=>"Description",
"p.note"=>"Note",

"p.note"=>"Note",
"ef.sku"=>"SKU",
"ef.refadv"=>"Ref adv",
);

note : adding and INDEX on thoses field in the mysql table  is required

ALTER TABLE llx_product_extrafields ADD INDEX(refadv);
ALTER TABLE llx_product_extrafields ADD INDEX(sku);
```
hope this will help a bit

mtahiue on 26 Jan 2017

👍2 ❤1

All 4 comments

It would be very cool :+1:

jpfox on 11 Sep 2015

here is how i did with dolibarr 4.0.3

caution !! : it is not a good pratice to hard code in the dolibarr core

"p.note"=>"Note",
"ef.sku"=>"SKU",
"ef.refadv"=>"Ref adv",
);

note : adding and INDEX on thoses field in the mysql table  is required

ALTER TABLE llx_product_extrafields ADD INDEX(refadv);
ALTER TABLE llx_product_extrafields ADD INDEX(sku);
```
hope this will help a bit

mtahiue on 26 Jan 2017

👍2 ❤1

Could be very useful 👍

dolibarr95 on 14 Feb 2017

This issue is stale because it has been open 1 year with no activity. If this is a bug, please comment to confirm it is still present on latest stable version. if this is a feature request, please comment to notify the request is still relevant and not yet covered by latest stable version. This issue may be closed automatically by stale bot in 15 days (you should still be able to re-open it if required).