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.
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