Twin Graph - Querying further than direct relationships (such as "grandchildren")

[danuw]

Twin Graph - Querying further than direct relationships (such as "grandchildren")

[danuw]

Quick update to say that this is sorted thanks to the new release of multi joins. https://docs.microsoft.com/en-us/azure/digital-twins/how-to-query-graph#query-with-multiple-joins.

It is limited to 5, but that is exactly what I need. So for the scenario above, the following query works with regards to providing the sensors in spaces (rooms and desks in this case). Sensor anywhere else did not come up in that query.

SELECT Sensor
FROM DIGITALTWINS Building
JOIN Floor RELATED Building.contains
JOIN Zone RELATED Floor.contains
JOIN Space RELATED Zone.contains
JOIN Sensor RELATED Space.contains
WHERE Building.$dtId = 'myBuildingId'

Using the IN operator (see example with list of floors here https://docs.microsoft.com/en-gb/azure/digital-twins/how-to-query-graph#query-best-practices) would have been good enough for 1 level of relationship, but really helps a lot.

Hope that helps others too.

Thanks to the ADT team for this feature.

Dan