I am trying to change the background color based on colors set in my database. I can get textColor to work and it changes to whatever I set it to but the background color doesn’t work.
Here is my query:
$scheduler->render_sql(“SELECT date_start, date_end, CONCAT(last_name, ': ', subject) AS subject, activities.notes AS description, assigned_to,
IF (bg_color IS NULL, ‘#ffffff’, bg_color) AS color, ‘#000000’ AS textColor
INNER JOIN projects ON projects.id = activities.project_id
INNER JOIN contacts ON contacts.id = projects.contact_id
LEFT JOIN activity_category ON activities.activity_category_id = activity_category.id
WHERE activity_type_id = “. $_GET[‘activity_type_id’] .” AND activities.date_start >= SUBDATE(NOW(), INTERVAL 30 DAY)
ORDER BY date_start ASC”, “id”, “date_start, date_end, subject, color, textColor, assigned_to, description”);
This is what my XML looks like
However it doesn’t work. The background color stays at the yellowish/gold color.