How to retrieve title block cascading list from agile plm database
Hi Keerthana,
Am not a SQL expert, but just to give you a brief idea, below is a simple select statement to fetch the cascading list values from DB for a 3 (three) levelled list (I hope that is query, as per my understanding)
select * from listentry where parentid in (select id from listname where parent_list in (select id from listname where parent_list in (select id from listname where parent_list in (select id from listname where name =’Your_List_Name‘)))) order by 4;
You can enhance it as per your need.
Cheers,
Swagoto