Recursive algorithm inside a report
Hello,
I have a tree structure inside my class (nodeID, level, page.parentID where parentID is the parent node of the node ID). I need to display the list of parent IDs dynamically depending on the level (If Level = L0 => parent ID = null else Parent ID = (select node ID where Level = selected Level).
Is that doable using a report definition?
Thanks a lot,
Rosy
Message was edited by: Marissa Rogers - Added category
Pegasystems
IN
(If Level = L0 => parent ID = null else Parent ID = (select node ID where Level = selected Level).
Does this mean someone will pass the selected level as a parameter to the report which will be used in the filter conditions?
Updated: 9 May 2016 4:31 EDT
Salame
Hi Rajiv, yes... the selected level of the child will be known and passed as parameter.
I din't know if the algo is correct, but, I need to display all its parent node... e.g if selectedLevel = L2 => display parent nodes of Level IN (L0,L1) ... etc.
Pegasystems
IN
You can use a SQL function to do that. Please see https://docs-previous.pega.com/how-create-custom-sql-functions-reporting