X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=CRM%2FCore%2FDAO%2FActionLog.php;h=3ebd410feccb48078c95cebfb5a256c2c4159491;hb=4a3c7961f8c578506bdc6b8c0909b1ea435a9739;hp=cdccd9babb9e38a4c722ce99700e6d648bff4513;hpb=e48ed441e7d36e73a3ea5554a8e59411e8eb9920;p=civicrm-core.git

diff --git a/CRM/Core/DAO/ActionLog.php b/CRM/Core/DAO/ActionLog.php
index cdccd9babb..3ebd410fec 100644
--- a/CRM/Core/DAO/ActionLog.php
+++ b/CRM/Core/DAO/ActionLog.php
@@ -134,6 +134,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_INT,
           'title' => ts('Action Schedule ID'),
           'required' => TRUE,
+          'where' => 'civicrm_action_log.id',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -144,6 +145,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_INT,
           'title' => ts('Action Schedule Contact ID'),
           'description' => ts('FK to Contact ID'),
+          'where' => 'civicrm_action_log.contact_id',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -156,6 +158,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'title' => ts('Entity ID'),
           'description' => ts('FK to id of the entity that the action was performed on. Pseudo - FK.'),
           'required' => TRUE,
+          'where' => 'civicrm_action_log.entity_id',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -168,6 +171,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'description' => ts('name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant'),
           'maxlength' => 255,
           'size' => CRM_Utils_Type::HUGE,
+          'where' => 'civicrm_action_log.entity_table',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -179,6 +183,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'title' => ts('Schedule'),
           'description' => ts('FK to the action schedule that this action originated from.'),
           'required' => TRUE,
+          'where' => 'civicrm_action_log.action_schedule_id',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -190,6 +195,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
           'title' => ts('Action Date And Time'),
           'description' => ts('date time that the action was performed on.'),
+          'where' => 'civicrm_action_log.action_date_time',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -200,6 +206,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_BOOLEAN,
           'title' => ts('Error?'),
           'description' => ts('Was there any error sending the reminder?'),
+          'where' => 'civicrm_action_log.is_error',
           'default' => '0',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
@@ -211,6 +218,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_TEXT,
           'title' => ts('Message'),
           'description' => ts('Description / text in case there was an error encountered.'),
+          'where' => 'civicrm_action_log.message',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -221,6 +229,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_INT,
           'title' => ts('Repetition Number'),
           'description' => ts('Keeps track of the sequence number of this repetition.'),
+          'where' => 'civicrm_action_log.repetition_number',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',
           'bao' => 'CRM_Core_BAO_ActionLog',
@@ -231,6 +240,7 @@ class CRM_Core_DAO_ActionLog extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_DATE,
           'title' => ts('Reference Date'),
           'description' => ts('Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)'),
+          'where' => 'civicrm_action_log.reference_date',
           'default' => 'NULL',
           'table_name' => 'civicrm_action_log',
           'entity' => 'ActionLog',