Skip to Content
avatar image
Former Member

promt order

Hi All,

I am having a promt in my universe whict promt a date in 'MON-YYYY' format now my problem is I want to sort this promt values so that end user must view values in order. for eg my current promt values are

MAY-2009

JAN-2009

MAR-2009

FEB-2009

I want my promt values should come as

JAN-2009

FEB-2009

MAR-2009

MAY-2009

Thanks and Regards

VD

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 26, 2009 at 07:00 AM

    HI All ,

    I just now resolve this issue by editing LOV of promt object as follows

    SELECT DISTINCT

    TO_CHAR(D_REF_MONTH.MON_YY,'MON-YYYY')

    FROM

    D_REF_MONTH order by To_date(TO_CHAR(D_REF_MONTH.MON_YY,'MON-YYYY'),'MON-YYYY')

    with do not generate sql while running and Export with universe ticked on .

    VD

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 26, 2009 at 07:01 AM

    HI All ,

    I just now resolve this issue by editing LOV of promt object as follows

    SELECT DISTINCT

    TO_CHAR(D_REF_MONTH.MON_YY,'MON-YYYY')

    FROM

    D_REF_MONTH order by To_date(TO_CHAR(D_REF_MONTH.MON_YY,'MON-YYYY'),'MON-YYYY')

    with do not generate sql while running and Export with universe ticked on .

    VD

    Add comment
    10|10000 characters needed characters exceeded