X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=CRM%2FCore%2FDAO%2FNote.php;h=84ecb5ba800690ed07e9dd4003d620eecfdc5c22;hb=a36434b96485cb086480c8deae0fe408b1ba1d01;hp=95b17c3bf8f09aff746577d85a5c68b25b2da9d9;hpb=bf144e748c568012e20bca579d1c742af1a0ef00;p=civicrm-core.git

diff --git a/CRM/Core/DAO/Note.php b/CRM/Core/DAO/Note.php
index 95b17c3bf8..84ecb5ba80 100644
--- a/CRM/Core/DAO/Note.php
+++ b/CRM/Core/DAO/Note.php
@@ -122,6 +122,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO {
           'title' => ts('Note ID'),
           'description' => ts('Note ID'),
           'required' => TRUE,
+          'where' => 'civicrm_note.id',
           'table_name' => 'civicrm_note',
           'entity' => 'Note',
           'bao' => 'CRM_Core_BAO_Note',
@@ -135,6 +136,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO {
           'required' => TRUE,
           'maxlength' => 64,
           'size' => CRM_Utils_Type::BIG,
+          'where' => 'civicrm_note.entity_table',
           'table_name' => 'civicrm_note',
           'entity' => 'Note',
           'bao' => 'CRM_Core_BAO_Note',
@@ -149,6 +151,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO {
           'title' => ts('Note Entity ID'),
           'description' => ts('Foreign key to the referenced item.'),
           'required' => TRUE,
+          'where' => 'civicrm_note.entity_id',
           'table_name' => 'civicrm_note',
           'entity' => 'Note',
           'bao' => 'CRM_Core_BAO_Note',
@@ -179,6 +182,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_INT,
           'title' => ts('Note Created By'),
           'description' => ts('FK to Contact ID creator'),
+          'where' => 'civicrm_note.contact_id',
           'table_name' => 'civicrm_note',
           'entity' => 'Note',
           'bao' => 'CRM_Core_BAO_Note',
@@ -190,6 +194,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_DATE,
           'title' => ts('Note Modified By'),
           'description' => ts('When was this note last modified/edited'),
+          'where' => 'civicrm_note.modified_date',
           'table_name' => 'civicrm_note',
           'entity' => 'Note',
           'bao' => 'CRM_Core_BAO_Note',
@@ -202,6 +207,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO {
           'description' => ts('subject of note description'),
           'maxlength' => 255,
           'size' => 60,
+          'where' => 'civicrm_note.subject',
           'table_name' => 'civicrm_note',
           'entity' => 'Note',
           'bao' => 'CRM_Core_BAO_Note',
@@ -217,6 +223,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO {
           'description' => ts('Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)'),
           'maxlength' => 255,
           'size' => CRM_Utils_Type::HUGE,
+          'where' => 'civicrm_note.privacy',
           'table_name' => 'civicrm_note',
           'entity' => 'Note',
           'bao' => 'CRM_Core_BAO_Note',