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


Current Time: Wed Sep 28 17:42:51 CDT 2016

Total time taken to generate the page: 0.10479 seconds