{"id":7389,"date":"2022-07-25T15:39:48","date_gmt":"2022-07-25T14:39:48","guid":{"rendered":"https:\/\/www.threesl.com\/blog\/?p=7389"},"modified":"2022-08-24T15:03:31","modified_gmt":"2022-08-24T14:03:31","slug":"showing-filtered-transitive-links-in-tables","status":"publish","type":"post","link":"https:\/\/www.threesl.com\/blog\/showing-filtered-transitive-links-in-tables\/","title":{"rendered":"Showing Filtered “Transitive” Links in Tables"},"content":{"rendered":"

Problem<\/h2>\n

We have created some links between Cradle items but we only want to see a filtered set of these links in our table.<\/p>\n

Rationale<\/h2>\n

Cradle<\/a> has a unique ability to follow cross references<\/a> transitively<\/a>. This means that although an item might not be directly cross referenced from it’s source, it might be linked indirectly through another item\/item type.<\/p>\n

Cradle also has the ability to name cross references referred to as link types<\/a> and even group sets of link types together referred to as link groups<\/a>.<\/p>\n

Combining these features can allow flexibility for the output of items that have some relationship to the source which will reduce the number of direct cross references required.<\/p>\n

For example, we would like to show dependencies between item type A and item type C but ONLY<\/strong> those that have a yellow and blue link type.<\/p>\n

\"Model
Defined Links Between Item Types<\/figcaption><\/figure>\n

We can see in the screenshot below that only A-6 and A-11 are transitively<\/a> linked to items of item type C with both a blue and a yellow link:<\/p>\n

\"Showing
Direct Links in a Nested Table<\/figcaption><\/figure>\n

Setting Link Groups<\/h2>\n

We can define a link group<\/a> in Project Setup in which we can select from the available link types<\/a>.<\/p>\n

\"Screenshot
Defining Link Groups<\/figcaption><\/figure>\n

This defined link group can be used in navigations<\/a>.<\/p>\n

Defining Navigations<\/h2>\n

Navigations<\/a> allow us to specify how we would like to follow the links that have been created between items. This is a very powerful feature as we can also specify that we would like to follow links transitively:<\/p>\n

\"Defining
Defining Navigations to Follow Cross References Transitively<\/figcaption><\/figure>\n

Using the Navigation in Views<\/h2>\n

We can now use the navigation to specify that we want to show links between item type A and item type C that are followed transitively but we ONLY<\/strong> want to show the group of links YELLOW AND BLUE<\/strong>. Remember that there are NO DIRECT<\/strong> links between these two item types. The cross references are from item type A to item type B and also from item type B to item type C:<\/p>\n

\"Defining
Using the Transitive Navigation in Views<\/figcaption><\/figure>\n

Applying this view<\/a>, we can see that only the YELLOW AND BLUE<\/strong> links are shown in the table. The remainder appear blank:<\/p>\n

\"Output
View Showing Transitive Cross References<\/figcaption><\/figure>\n

Using the Navigation in Queries<\/h2>\n

We might wish to only show items in our table that have these links in preference to showing all items and just appearing blank where the transitive link does not exist. We can achieve this in the Query Details<\/a> dialog:<\/p>\n

\"Using
Filtering Items Non-Linked Items in a Query<\/figcaption><\/figure>\n

This will now filter out of the list any items that do not match the navigation criteria:<\/p>\n

\"Screenshot
Link Table Only Showing Items Where Transitive Link Exists<\/figcaption><\/figure>\n

Showing Path in a Tree Style<\/h2>\n

If we followed the path in a tree style<\/a> showing downward links, we can see that item type A (A-6 and A-11) are not directly linked to item type C (C-1). They go through item type B (B-2):<\/p>\n

\"Screenshot
Links shown in Tree Style<\/figcaption><\/figure>\n

Summary<\/h2>\n

Cradle provides a unique ability to allow cross references to be followed transitively (through other items).<\/p>\n

Transitive navigations can be applied to views and queries. This provides a very powerful filtering mechanism that allows us to show non-direct dependencies between items.<\/p>\n