OraFAQ Forum: Reports & Discoverer » 'Connect By' and 'Start With' in Discoverer

Home » Developer & Programmer » Reports & Discoverer » 'Connect By' and 'Start With' in Discoverer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

'Connect By' and 'Start With' in Discoverer [message #427158]

Wed, 21 October 2009 06:34

adelshehri
Messages: 12
Registered: July 2009

Junior Member

Hello,

I have a hierarchal query to show all child organizations under the parameter ':Parent_ID'

This is the query, I execute it in SQL Developer normally:

SELECT el.organization_id_child, ch.name,level
     FROM hr.hr_all_organization_units org,
  hr.PER_ORG_STRUCTURE_ELEMENTS el      ,
  hr.hr_all_organization_units ch
  WHERE el.org_structure_version_id         = 61
AND org.organization_id                     = el.organization_id_parent
AND ch.organization_id                      = el.organization_id_child
START WITH el.organization_id_parent = :Parent_ID
CONNECT BY el.organization_id_parent = PRIOR el.organization_id_child

in the below line:
START WITH el.organization_id_parent = :Parent_ID
The hierarchal query will start with parameter value to show all childes under that organization...

How can I use this simple query in Discoverer !! I am trying to find the START WITH in the discoverer also can not put this query in a new custom folder without removing the parameters.

Please Help...

Regards

[Updated on: Wed, 21 October 2009 06:47]

Report message to a moderator

Previous Topic:	Run procedure before retrieve the data
Next Topic:	reports rwclient.sh mode=character not formatting to landscape

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 11:28:09 CDT 2024