Answers.Body: <p>Be really careful of what you are doing. But the delayed actions are stored in the <code>civicrm_queue_item</code> database table.</p>
  
  <p>The column <code>release_time</code> indicates the date from which the action is going to be executed. The data for the action is stored as a serialized data blob in the column <code>data</code>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-06T07:23:11.873Z
Answers.Text: Aha, great - thanks! and yes, i'll be testing a lot before deciding whether or not to make any changes to the live site!
Answers.UserDisplayName: user3016811
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-06T07:18:20.693Z
Answers.LastActivityDate: 2018-08-06T07:18:20.693Z
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Body: <p>I've got a CiviRule that triggers when a membership is added and is delayed by 3 months, but i want to back date it for existing memberships, ie any membership less than 90 days old (if it was 88 days old, my rule would act in 2 days time)</p>
  
  <p>Assuming there's not a clever way of doing this up front, i'm happy to manipulate things directly in the database, but haven't found anything but the civirule_rule_log which actually changes on triggered conditions - where is the part that acts?</p>
  
  <p>thanks!</p>
  
Tags: <civirules>
Title: CiviRules - where is the data stored in the database? - backdating
ThreadText: # CiviRules - where is the data stored in the database? - backdating
  
  (Asked by: username_0 on 2018-08-05)
  
  I've got a CiviRule that triggers when a membership is added and is delayed by 3 months, but i want to back date it for existing memberships, ie any membership less than 90 days old (if it was 88 days old, my rule would act in 2 days time)
  
  Assuming there's not a clever way of doing this up front, i'm happy to manipulate things directly in the database, but haven't found anything but the civirule\_rule\_log which actually changes on triggered conditions - where is the part that acts?
  
  thanks!
  
  **Tags:** civirules
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-08-06. Score: 6 | Accepted answer
  
  Be really careful of what you are doing. But the delayed actions are stored in the `civicrm_queue_item` database table.
  
  The column `release_time` indicates the date from which the action is going to be executed. The data for the action is stored as a serialized data blob in the column `data`.
  
  > **Comments:**
  > **username_0**: Aha, great - thanks! and yes, i'll be testing a lot before deciding whether or not to make any changes to the live site!  
  
  ---
  
  