I have a rules component that i want to trigger on specific time that is set by end user. in my case i have a form where user create rental property and select the rent date there. then i have another form of alerts where user can set alerts related to rentals. like user wants alert before 2 days of rental date. I am able to set the rental date but unable to get the value of alerts section to check what value the end user has set to get an alert. I tried to put sql query in 'PHP Evaluation section' but in scheduling section it shows the blank date. Rule that i have creatrted:
component: Schedule reminder to end user Rule: Schedule rental alerts action: schedule component evaluation data-selector:node:field-rental-start-date php evaluation: $query = db_query("SELECT field_days_before_the_rent_value FROM field_data_field_days_before_the_rent"); foreach($query as $result){$res = $result->field_days_before_the_rent_value;} return $value - $res;
Please help me here how i can get the field_days_before_the_rent_value.