Label Sample–Equipment Name of Nozzle

x x x x x x x x x

x x x x x x x x x

x x x x x x x x x

x x x x x x x x x

<RETURNED_PROPERTIES>

<RETURNED_PROPERTY Name=”Name” SQLType=”BStr”><PATHS><PATH SourceType=”IJDistribPort” SourceBOC=”PipeNozzle” DestinationInterface=”IJNamedItem” DestinationProperty=”Name” DestinationBOC=”Equipment&amp;Furnishing” Concatenate=”No” PathSeparator=””>

<STROKES>

<STROKE Interface=”IJDistribPort” RelationCollection=”DistribPart” Recursive=”No” Filter=”First” IsVirtualRelationship=”No”/></STROKES>

</PATH>

</PATHS>

</RETURNED_PROPERTY>

</RETURNED_PROPERTIES>

x x x x x x x x x

x x x x x x x x x

如下为相关SQL查询示例：取值为Nozzle name以及Equipment Name。

x x x x x x x x x

select  x8.ItemName as equipment,

x9.ItemName as nozzle 

 from JPipeNozzle x3 

join JDistribPort x2 on x2.oid = x3.Oid

join XDistribPorts x6 on x6.OidDestination =x2.oid

join JSmartEquipment x7 on x7.Oid = x6.OidOrigin

join JNamedItem x8 on x8.Oid=x7.Oid

join JNamedItem x9 on x9.oid = x3.Oid