Filter Object Table on linked Property

Curious learner here looking for help on the below.

I have two ontology object types:

  • Deal_Valuation (parent) on the Left table

  • Deal_Valuation_Asset (child) on the right table

There is a link type connecting them through the property:

“Deal_Valuation_ID ↔ Deal_Valuation_ID”

Looking at the image, I want to filter the object list on the right to only show assets which contain the Deal record line selected on the left. Essentially, it’s like clicking on different customers shopping carts on the left. then seeing the item contents of the carts on the right.

Within Workshop i have configured the below;

Object Table (left) - Input Data - Deal_Record_Object_Set, with an active object called selected_deal.

on the right i have an object list with the main object set as the Asset_Object set. I need to configure the filters on the table appropriately so it only shows the list of assets who’s ID matches the selected object on the left.

I’ve tried multiple filters and attempts and would greatly appreciate any help in how to best approch this.

I think you have to traverse from the active object in (deal_valuation) to get the linked objects (deal_valuation_asset).

In the object set to the right use the active object from the left (selected_deal) as start and then choose get linked object → choose “Deal_valuation_asset”.

unfortunately workshop doesn’t allow for (Selected_Deal) as an active object set to be used in this context as it’s a static string value.

I’ve also tried to configure the object set using both the child and parent object sets and attached the selected_deal within the filters however, no selected_deal is visible to click.

Below I’ve then tried linking across property and still not being able to achieve the desired outcome. where the table presents the object’s with linked Objects ID’s on the left.

You are almost there.

  1. As input data choose a new object set.
  2. The new object set should start with the active object.
  3. Under traverse to → get linked objects you chose the Deal_Valuation_Asset.

Example:

Thanks, Bobbyb this is solved. really appreciated

1 Like