Smart 3D中SQL filter示例

📅 2024-07-21 👤 pipingpig 📁 Smart3D , 命令与自定义 ✏️ 更新于 2026-08-20 👁 2 💬 0

x x x x x x x x x x x x x x

过滤当前项目中的piperun：

select oid from jrtePiperun

x x x x x x x x x x x x x x

名字中包含指定内容的piperun：

x x x x x x x x x x x x x x

select a.oid from JRtePipeRun a

join JNamedItem b on b.oid=a.oid

where b.ItemName like ‘%1C0031%’

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

select by filter测试

x x x x x x x x x x x x x x

如上，可以发现piperun并无实体，下面测试加载piping parts有实体的对象：

x x x x x x x x x x x x x x

select oid from JRtePipePart

union

select a.oid from JRteCompOccur a

join JDPipeComponent b on a.oid =b.oid

x x x x x x x x x x x x x x

加载仪表件：

select oid from JRteInstrument

x x x x x x x x x x x x x x