Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
en:modifications:search-custom-productfields-during-productsearch [2015/02/06 15:31]
swarnat
en:modifications:search-custom-productfields-during-productsearch [2015/02/06 15:32] (current)
swarnat
Line 31: Line 31:
  $query = '​SELECT label, crmid, setype, createdtime FROM vtiger_crmentity ​  $query = '​SELECT label, crmid, setype, createdtime FROM vtiger_crmentity ​
  INNER JOIN vtiger_products ON  vtiger_products.productid = vtiger_crmentity.crmid  INNER JOIN vtiger_products ON  vtiger_products.productid = vtiger_crmentity.crmid
- INNER JOIN vtiger_productcf ON  + INNER JOIN vtiger_productcf ON vtiger_products.productid = vtiger_productcf.productid ​ 
- vtiger_products.productid = vtiger_productcf.productid WHERE (label LIKE ? OR cf_645 LIKE ?) AND vtiger_crmentity.deleted = 0 +                          ​WHERE (label LIKE ? OR cf_645 LIKE ?) AND vtiger_crmentity.deleted = 0 
  AND vtiger_products.discontinued = 1 AND setype = ?';  AND vtiger_products.discontinued = 1 AND setype = ?';
  $params[] = "​%$searchKey%";​  $params[] = "​%$searchKey%";​