Manejo de Calendarios/Calendar Oracle APEX parte 1

Crear un calendario en Oracle APEX es de lo mas sencillo. Además que nos permite una alta personalización, al utilizar librerías JS de fullcalendar.

En un query definimos parametros importantes:
Nombre
Fecha de Inicio
Fecha Fin
Y como alternativa:
ID : En caso de usar la funcionalidad de editar/eliminar
Css_Class: Para agregar colores

 select id 
, project
, task_name
, start_date
, end_date
, case status
when \'Open\' then \'apex-cal-green\'
when \'Pending\' then \'apex-cal-yellow\'
when \'Closed\' then \'apex-cal-red\'
when \'On-Hold\' then \'apex-cal-black\'
end as css_class
from eba_demo_cal_projects

Opciones:

  • Uso de ToolTip

  • Colores
    • apex-cal-red
    • apex-cal-cyan
    • apex-cal-blue
    • apex-cal-bluesky
    • apex-cal-darkblue
    • apex-cal-green
    • apex-cal-yellow
    • apex-cal-silver
    • apex-cal-brown
    • apex-cal-lime
    • apex-cal-white
    • apex-cal-gray
    • apex-cal-black
    • apex-cal-orange

  • A partir de APEX 18 podemos usar Hints en el query
  • Mostrar en formato, mes , semana, día, lista




  • Hora formato 12 y 24
  • Exportar CSV, iCal, xml
  • APEX 18: Rest WebService Json
  • Opciones avanzadas en JavaScript
function ( pOptions) {
pOptions.titleFormat = \"[Conference Schedule]\"; // custom title
pOptions.minTime = \"07:00:00\"; // hide slots before minTime
pOptions.maxTime = \"18:00:00\"; // hide slots after maxTime
pOptions.columnFormat = {month: \'\', week: \'dddd\', day: \'dddd\'}; // week view column headings
pOptions.slotDuration = \"00:15:00\"; // custom slot duration
pOptions.weekNumbers = true; // show week numbers
pOptions.weekNumberTitle = \"CW\";
return pOptions;
}

Published by Angel O. Flores Torres

System engineer, Applications engineer, working with C# and Oracle Apex 5, 5.1 since 2017. I specialize in Oracle APEX (Oracle Application Express )

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: