Label Sample–Equipment Name of Nozzle

x x x x x x x x x

x x x x x x x x x

本文介绍一个label，用于返回管口所在的设备名称。

如上所示，相关起点以及关系等为：

起点：Pipe Nozzle；

关系：Object to Distribution Port

目标为：Equipment & Furnishings

相关Rqe内容关键字段如下：

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

x x x x x x x x x

该label的主要是为了查询模型中“哪些设备连接了哪些管线”。其中的一部分就是这个Nozzle属于哪个设备。此外，从Nozzle起始，我们还可以查询到该Nozzle连接了哪些管件，哪个区域的哪些管线。

x x x x x x x x x