css - 使用条件从日历区域导出 CSV

Question

我有页面：P1 并在内容正文中创建了一个带有日历的区域。

此日历显示我数据库中的所有约会。我从日历的属性部分启用了导出序列，但我收到的数据是从开始到今天的所有约会！从日历导出时如何创建特定条件，因为我只想导出从今天到本月底的事件。这是我的看法：

CREATE OR REPLACE FORCE VIEW "APPOINTMENTS" ("ID", "SESSION_DISPLAY", "SESSION_DATE", "SESSION_END", "CSS_CLASS") AS 
  select Sessions.ID,
to_char(Sessions.SESSION_DATE, 'DD-MM-YY - HH24:MI') || ' -> ' || clients.First_name || ' ' || Clients.Last_Name 
|| ' -> ' || SESSION_STATUS.STATUS_NAME || ' και ' || PAYMENT_STATUS.PAYMENT_DESCRIPTION as Session_Display,
Sessions.SESSION_DATE,
Sessions.SESSION_STOP,
case when SESSION_STATUS.ID = 5 and PAYMENT_STATUS.ID = 2 then 'apex-cal-green'
    when SESSION_STATUS.ID = 5 and PAYMENT_STATUS.ID = 1 then 'apex-cal-red'
    when SESSION_STATUS.ID = 3 then 'apex-cal-yellow'
    when SESSION_STATUS.ID = 4 then 'apex-cal-black'
    else 'apex-cal-blue'
end as css_class
from SESSION_STATUS SESSION_STATUS,
    SESSIONS SESSIONS,
    PAYMENT_STATUS PAYMENT_STATUS,
    CLIENTS CLIENTS 
where SESSIONS.CLIENTS_ID=CLIENTS.ID
and SESSIONS.PAYMENT_STATUS=PAYMENT_STATUS.ID
and SESSIONS.STATUS=SESSION_STATUS.ID
/
CREATE OR REPLACE FORCE VIEW "APPOINTMENTS" ("ID", "SESSION_DISPLAY", "SESSION_DATE", "SESSION_END", "CSS_CLASS") AS 
  select Sessions.ID,
to_char(Sessions.SESSION_DATE, 'DD-MM-YY - HH24:MI') || ' -> ' || clients.First_name || ' ' || Clients.Last_Name 
|| ' -> ' || SESSION_STATUS.STATUS_NAME || ' και ' || PAYMENT_STATUS.PAYMENT_DESCRIPTION as Session_Display,
Sessions.SESSION_DATE,
Sessions.SESSION_STOP,
case when SESSION_STATUS.ID = 5 and PAYMENT_STATUS.ID = 2 then 'apex-cal-green'
    when SESSION_STATUS.ID = 5 and PAYMENT_STATUS.ID = 1 then 'apex-cal-red'
    when SESSION_STATUS.ID = 3 then 'apex-cal-yellow'
    when SESSION_STATUS.ID = 4 then 'apex-cal-black'
    else 'apex-cal-blue'
end as css_class
from SESSION_STATUS SESSION_STATUS,
    SESSIONS SESSIONS,
    PAYMENT_STATUS PAYMENT_STATUS,
    CLIENTS CLIENTS 
where SESSIONS.CLIENTS_ID=CLIENTS.ID
and SESSIONS.PAYMENT_STATUS=PAYMENT_STATUS.ID
and SESSIONS.STATUS=SESSION_STATUS.ID
/

我仍然希望我的日历显示所有事件（根据此视图），但我只想导出当前事件（从今天到本月底

标签： cssoracle-sqldeveloperoracle-apexoracle-apex-5oracle-apex-5.1