Report Parameter Sorting [message #201100] |
Wed, 15 November 2006 22:06 |
Eclipse User |
|
|
|
Originally posted by: smurfieu.gmail.com
I am having an issue with making the "Enter Parameters" window display the
choices in the order returned by the query.
I am using a dynamic combo box and "Sort alphabetically when prompting" is
UN-checked.
I want the parameters to return in a descending order (which I verified in
both TOAD and the preview results pane in the data set window).
I am doing a simple query:
select distinct to_char(tara.CYCLE_DATE,'YYYY-MM-DD') as CYCLE_DATE
from AS_REPORT_AGG tara
order by to_char(tara.CYCLE_DATE,'YYYY-MM-DD') DESC
Does anyone have any insight on this? I have been searching for quite
awhile, but everything I have found seems to be well beyond the scope of
this problem.
Thanks in advance.
|
|
|
Re: Report Parameter Sorting [message #201386 is a reply to message #201100] |
Thu, 16 November 2006 21:00 |
|
This looks like it may be a bug. Can you log a bugzilla entry for this?
Jason
"Matthew" <smurfieu@gmail.com> wrote in message
news:6429762ec95c6a54761b1e28aefe7210$1@www.eclipse.org...
>I am having an issue with making the "Enter Parameters" window display the
>choices in the order returned by the query.
> I am using a dynamic combo box and "Sort alphabetically when prompting" is
> UN-checked.
>
> I want the parameters to return in a descending order (which I verified in
> both TOAD and the preview results pane in the data set window).
>
> I am doing a simple query:
>
> select distinct to_char(tara.CYCLE_DATE,'YYYY-MM-DD') as CYCLE_DATE
> from AS_REPORT_AGG tara
> order by to_char(tara.CYCLE_DATE,'YYYY-MM-DD') DESC
>
> Does anyone have any insight on this? I have been searching for quite
> awhile, but everything I have found seems to be well beyond the scope of
> this problem.
>
> Thanks in advance.
>
|
|
|
Powered by
FUDForum. Page generated in 0.03277 seconds