Feature Request: Search in extrafields

[low5]

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

[jpfox]

It would be very cool 👍

[mtahiue]

here is how i did with dolibarr 4.0.3

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

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

[dolibarr95]

Could be very useful 👍

[github-actions]

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).

[jtraulle]

Seems to be still not implemented in V16.0.3

[github-actions]

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 10 days (you should still be able to re-open it if required).