select
substr(username,0,2) user_avatar,
'u-color-'||ora_hash(username,44)||'-txt' user_color,
user_name,
event_date,
event_type,
event_title,
event_desc,
case status
when 'open' then 'fa fa-clock-o'
when 'closed' then 'fa fa-check-circle-o'
when 'on-hold' then 'fa fa-exclamation-circle'
when 'pending' then 'fa fa-exclamation-triangle'
end event_icon,
case status
when 'open' then 'is-new'
when 'closed' then 'is-removed'
when 'on-hold' then 'is-updated'
when 'pending' then 'is-updated'
end event_status,
url event_link
from dual