SQL : order by siblings ????

[system]

Hy,
I’ve got a question about the post (Oracle SQL to display Users and Groups)

Oracle SQL to display Users and Groups

Author: DCMatt -- Search a repository for user and groups -- 1. Change the act.m_actor_n_type as needed. -- 2. Substitue <Top Level Group Name> as appropriate. -- EXPECTED RESULTS: A rendering of the requested Groups and Users. SELECT LPAD(' ',(level-1)*5,' ') ||DECODE(act.m_actor_n_type, 1, 'GROUP: ', NULL) ||act.m_actor_c_name FROM obj_m_actorlink lnk, obj_m_actor act WHERE act.m_actor_n_id = lnk.m_actl_n_actorid AND act.…

It works fine within Sql Plus. My question (maybe dummy ?) is :

I tried to create an object (with the SQL provided) in order to execute it inside Reporter. It works however, the column is sorted : so the result is unexploitable. Is-it possible to use it inside BO or not ?

Thanks for your answer.

---

Ty_Bou (BOB member since 2005-02-16)

[system]

What is probably going on is the standard BusinessObjects sorting process is overwriting the sort provided by the query.

---

Dave Rathbun (BOB member since 2002-06-06)