How to retrieve title block cascading list from agile plm database

How can we retrieve cascading list of title block from the database

Agile User Asked on May 30, 2021 in Product Collaboration.
Add Comment
1 Answer(s)

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

Agile Expert Answered on June 1, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.