PES_ListItemDependency

PES_ListItemDependency stores information about dependencies for specific values in a list attribute.

Columns

Name Type Length Description
att_ParentUID int 4 Attribute parent ID.
li_ParentUID int 4 List item parent ID.
att_ChildUID int 4 Attribute child ID.
li_ChildUID int 4 List item child ID.
li_Precedence int 4 List item precedence.
nsp_UID int 4 Namespace ID.
li_IsOrphan bit 1 Whether the list item is an orphan.

Agile Planner Representation

List items are represented in Agile Planner in the Configuration | Attributes Setup view, under the Attribute Dependencies tab.

image

SQL Example

SELECT*
FROM PES_ListItemDependency 
SELECT p.att_Name as'ParentAttribute', c.att_Name as'ChildAttribute', pli.li_Name as'ParentListItem', cli.li_Name as'ChildListItem'
FROM PES_ListItemDependency pc
      INNERJOIN PES_Attribute p ON pc.att_ParentUID = p.att_UID
      INNERJOIN PES_Attribute c ON pc.att_ChildUID = c.att_UID
      INNERJOIN PES_ListItem pli ON pc.li_ParentUID = pli.li_UID
      INNERJOIN PES_ListItem cli ON pc.li_ChildUID = cli.li_UID  
att_ParentUID li_ParentUID att_ChildUID li_ChildUID li_Precedence nsp_UID     li_IsOrphan
------------- ------------ ------------ ----------- ------------- ----------- -----------
250           61           129          22          1             3           0
250           62           129          29          1             3           0
250           62           129          22          2             3           0  
ParentAttribute    ChildAttribute   ParentListItem   ChildListItem
------------------ ---------------- ---------------- -------------
Completed          Status           Yes              Normal
Completed          Status           No               Blocked
Completed          Status           No               Normal