Hi,
I am trying to arrange a set of events for a particular day in a particular order when displayed in APEX Calendar but the events are appearing in some fashion but not in the desired order.
My events are arranged as External Events, Internal Events and Workdays. I am trying to get Workdays to appear first, then Internal Events and then External events.
I have tried a Order By Desc on Event_Type column but it doesn't seem to work. I have even tried inner query but that is also not working.
Following is my inner query code:
select ID,
EVENTS,
EVENT_DATE,
EVENT_TYPE
from (select ID,
EVENTS,
EVENT_DATE,
EVENT_TYPE
from EVENT_CALENDAR
order by EVENT_TYPE desc)
Any help on this would really be appreciated.