on 04-27-2020 1:02 PM
Heirarchy function returns empty set, though data is present in source.
SELECT * FROM HIERARCHY( SOURCE (SELECT "TEAM_ID" as node_id,"REPORTSID" as parent_id,"TEAM_NAME" FROM "abc.TeamStructure") START WHERE "REPORTSID" IS NULL )
Please let me know, is ther any problem in sql.How can i achieveheirarchical functionality.
Hej Chanikya,
can you please try to run the inner/source query?
SELECT "TEAM_ID" as node_id,"REPORTSID" as parent_id,"TEAM_NAME" FROM "abc.TeamStructure" WHERE "REPORTSID" IS NULL
if this query returns a non-empty result, then the hierarchy result should also be non-empty.
In case you are not aware, the hierarchy developer guide provide some real nice examples.
Regards, Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
11 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.