 Automatic sort made by Discoverer [message #377299] |
Mon, 22 December 2008 04:55  |
jb084
Messages: 14
Registered: April 2008
|
Junior Member |
|
|
Hello evertbody,
I've got a SQL view, based on a query with a CONNECT By clause. I added it in the EUL, and want to display it in Discoverer Desktop. The problem is that Discoverer makes an automatic sort, based on the column he displays.
Here is the view :
select A,
id
id_father
text_to_display
level
order
from my_table
connect by
prior id=father_id
start with
father_id is null
order siblings by
order
level
The query works fine (thanks for her  ), but when I display this view in Discoverer, it orders the rows by the text_to_display !
Is there an option in Discoverer that forbid him to sort the rows ? Is there a workaround I haven't thought ?
Thanks for your help,
[EDITED by LF: removed the [ANSWERED] note from topic title, written at the moment when jb084 thought that he/she got the answer]
[Updated on: Mon, 22 December 2008 10:15] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
