APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Apex 4.0 How to use Function in Interactive report filter?

thomasoAug 6 2010 — edited Aug 6 2010

Dear all,
Sorry for nub question, but if there is a way to create and save "saved report" with filter condition using a function?
What I want to do is to create an interactive report on table called TASK.
Table does have two columns I want to use for filtering:
FDate - DATE - From date
TDate - DATE - To date
Then I need to create several saved reports:
last week Tasks = where FDate between sysdate - 7 AND sysdate...
last month Tasks = where FDate between ADD_MONTH(sysdate,-1) AND sysdate...
but,
Interactive Report Filter doesn't accept sysdate, or calls to ADD_MONTH functions.
Is there an easy way to setup this functionality?
TIA
Thomas

Sorry for double post...

Edited by: thomaso on Aug 6, 2010 12:04 PM

This post has been answered by Anthony Rayner-Oracle on Aug 6 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2010

Added on Aug 6 2010

#apex-discussions

3 comments

1,509 views