Home » Developer & Programmer » Reports & Discoverer » 'Connect By' and 'Start With' in Discoverer
'Connect By' and 'Start With' in Discoverer [message #427158] Wed, 21 October 2009 06:34
Messages: 12
Registered: July 2009
Junior Member

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.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...


[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:

Current Time: Tue Jul 25 22:06:07 CDT 2017

Total time taken to generate the page: 0.11265 seconds