When you use two related entity families as query sources, GE Digital APM creates an inner join between the two entity families by default. This inner join causes the query results to include only the records that are linked through the specified relationship.
If two entity families are not related through a relationship family, you can manually create an inner join to connect one or more fields in one family to one or more fields in the other family.
The following table shows the line style that appears in the design canvas to represent GE Digital inner joins.
| Join Type | Line Style |
|---|---|
| GE Digital Inner Join |
|
Suppose you add the Equipment entity family, Work History entity family, and Has Work History relationship family as query sources. Assuming that the Has Work History family relates the Equipment family to the Work History family, GE Digital APM will create an inner join between the Equipment and Work History families by default. As a result, the query results will return only Equipment records that are linked to a Work History record through the Has Work History relationship. The query results will not include any Equipment records that are not linked to a Work History record or any Work History records that are not linked to an Equipment record.
Copyright © 2018 General Electric Company. All rights reserved.