PES_ListDependency

PES_ListDependency stores dependencies for list attributes, as defined from the Attributes Setup | Attributes Dependencies view in Agile.

Columns

Name	Type	Length	Description
att_ParentUID	int	4	Parent attribute ID.
att_ChildUID	int	4	Child attribute ID.
nsp_UID	int	4	Namespace ID.

Agile Planner Representation

Dependencies for list attributes are represented in Agile Planner in the Configuration | Attributes Setup view, under the Attributes Dependencies tab.

SQL Example

SELECT*
FROM PES_ListDependency 
SELECT p.att_Name as'Parent', c.att_Name as'Child'
FROM PES_ListDependency pc
      INNERJOIN PES_Attribute p ON pc.att_ParentUID = p.att_UID
      INNERJOIN PES_Attribute c ON pc.att_ChildUID = c.att_UID  
att_ParentUID att_ChildUID nsp_UID
------------- ------------ -----------
250           129          3  
Parent       Child
------------ -------
Completed    Status