Saturday, August 7, 2010

Calendar in Concurrent Request Parameter

One of the problem with concurrent request date parameter is that we cannot attach a calendar the way we have for forms. But there is an alternate solution to have a List of values.

Create a view using following query

   (SELECT     (TO_DATE (SYSDATE - 1 + LEVEL, 'DD-MON-RRRR')) date_range
             , (TO_CHAR (SYSDATE - 1 + LEVEL, 'Month, DD RRRR')) date_word
    FROM       DUAL x
    CONNECT BY LEVEL <= 1000)

In the above query sysdate can be replaced with the date range as per requirement. Also the above query will result in 1000 records which can be altered by changing the connect by level value.

Now that we have created a view, a table value set can be created based on it and this can be used in the request parameter.

No comments:

Post a Comment