Skip to content
Snippets Groups Projects

Fix SQL to remove deleted records from result. refs #46

Merged Alan Lord requested to merge lord_alan/vtigercrm:46_deletedRecords into master
+ 1
1
Compare changes
  • Side-by-side
  • Inline
@@ -1441,7 +1441,7 @@ class Vtiger_Module_Model extends Vtiger_Module {
$sql = "SELECT vtiger_crmentity.crmid FROM vtiger_crmentity";
if($tablename == 'vtiger_crmentityrel'){
$sql .= " INNER JOIN $tablename ON ($tablename.relcrmid = vtiger_crmentity.crmid OR $tablename.crmid = vtiger_crmentity.crmid)
WHERE ($tablename.crmid IN (". generateQuestionMarks($recordIds).")) OR ($tablename.relcrmid IN (". generateQuestionMarks($recordIds)."))";
WHERE ($tablename.crmid IN (". generateQuestionMarks($recordIds).") OR $tablename.relcrmid IN (". generateQuestionMarks($recordIds)."))";
foreach ($recordIds as $key => $recordId) {
array_push($params, $recordId);
}
Loading