AnsweredAssumed Answered

Knowledge Category Mapping

Question asked by ArunavaS on Feb 1, 2019
Latest reply on Feb 7, 2019 by ArunavaS

Hello Experts,

 

I am querying table O_INDEXES to get the mapping of relational_id field. In the SQL display(output) I need to convert relational_id with the corresponding "caption" of each segment.

 

For example an entry under relational_id field (Eg. 1-400168-400564-400197) should be displayed like : Top-My Service-Child Service-Grand Child Service.

I tried with several self-join queries but eventually fails. Did anyone try it before? Any leads/helps will be appreciated.

 

Thanks

ArunavaS

Outcomes