过滤器表达式。
有关表达式语法，请参见 http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx。
|
名称 |
样例值：T 形三通 |
|
价值 |
样例值：类型 LIKE 'TEE*' |
| 名称 | 价值 |
|
三通 |
键入 LIKE 'TEE*' |
|
渡 |
键入 LIKE 'CROSS*' |
|
支持 |
type='支持' |
|
FieldFitWeld |
类型 ='FieldFitWeld' |
|
ReducerLike |
类型 LIKE 'Reducer*' |
|
FlangeLike |
键入 LIKE '*FLANGE' |
|
MsgDimensioned |
键入 LIKE 'MESSAGE*' AND UNDIMENSIONED IS NULL |
|
ValveEndNotFlange |
类型 = 'VALVE' AND （End1 <> 'FL' OR END2 <> 'FL'） |
|
BWValve |
类型 =“VALVE”AND End1 =“BW” |
|
TWValve |
类型 =“VALVE”AND End1 =“TW” |
|
SWValve |
类型 =“VALVE”AND End1 =“SW” |
|
FLValve |
类型 =“VALVE”AND End1 =“FW” |
|
CPValve |
类型 =“VALVE”AND End1 =“CP” |
|
InlineBranch |
键入类似“TEE*”OR类型类似于“CROSS” |
|
OletAndServiceDrAvCvOrRv |
类型=“支管台”AND （服务 = 'DR' OR 服务 = 'AV' OR 服务 = 'CV' OR 服务 = 'RV'） |
|
垫片 |
类型 = ''Gasket' |
|
帽 |
类型 = 'CAP' |
|
BlindFlangeAndCaps |
类型=“FLANGE-BLIND”OR类型=“CAP” |
|
EndLike |
键入 LIKE 'END-*' |
|
EndConnection |
类型 = 'EndConnection' |
|
WeldFieldItem |
类型 LIKE '*Weld' AND （类别 =“ERECTION-ITEM”OR 类别=“OFFSHORE-ITEM”） |
|
WeldShopItem |
类型 LIKE '*Weld' AND Category='FABRICATION-ITEM' |
|
焊接 |
键入 LIKE '*Weld' |
|
AnyItem |
键入 LIKE '*' |
|
FieldItem |
Category='ERECTION-ITEM' OR Category='OFFSHORE-ITEM' |
|
ShopItem |
Category='FABRICATION-ITEM' |
|
组件 |
（FieldItem AND （NOT类型=“焊接”）） OR （类型 =“阀”AND 终点 1 =“FL”） OR （类型 =“管道”AND长度 =MaxPipeLength） |
|
Components_MaxPipeLengthSegmentsAsSpools |
（FieldItem AND （NOT类型=“焊接”）） OR （类型=“阀”AND End1=“FL”） |
|
ItemCodeNotNull |
NOT [ITEM-CODE] IS NULL |
|
管 |
类型 =“管道” |
|
翼缘 |
类型 = '法兰' |
|
拟 合 |
NOT （类型 = '管道' OR 类型 = 'Gasket' OR 类型 = '法兰' OR 类型 = '螺栓' OR 类型 = '阀' OR 类型 = '支OR 类型 = '仪表' OR 类型 = '支撑'） |
|
FittingAndInstrument |
NOT （类型 = '管道' OR 类型 = 'Gasket' OR 类型 = '法兰' OR 类型 = '螺栓' OR 类型 = '阀' OR 类型 = '支承'OR 类型 '支撑'） |
|
螺栓 |
类型 =“螺栓” |
|
扣件 |
类型 ='Gasket' OR 类型=“螺栓” |
|
阀 |
类型 =“阀门” |
|
支箱 |
类型 =“支管台” |
|
ItemCodeNotNullAndCategoryFabItem |
NOT [ITEM-CODE] IS NULL AND 类别=“FABRICATION-ITEM” |
|
ItemCodeNotNullAndCategoryErecItem |
NOT [ITEM-CODE] IS NULL AND 类别=“ERECTION-ITEM” |
|
ExistingFalseSpoolNumberNotEmpty |
现有 = 'false' AND SpoolNumber <> '' |
|
NotBoltOrWeld |
类型 <> 'BOLT' AND类型 NOT LIKE '*Weld' |
|
FieldWeld |
类型 = 'FieldWeld' |
|
ReducerEccAndFlatDirectionDown |
类型 = 'REDUCER-ECCENTRIC' AND [FLAT-DIRECTION]='DOWN' |
|
ReducerEccAndFlatDirectionUp |
类型 = 'REDUCER-ECCENTRIC' AND [FLAT-DIRECTION]='UP' |
|
OletAndSkeyWtbw |
类型 = 'olet' AND SKEY='WTBW' |
|
OletAndSkeyLascLaswOrLabw |
类型 = '支LASC' AND （SKEY=''OR SKEY='LASW'OR SKEY='LABW'） |
|
OletAndSkeyThsc |
类型 = 'olet' AND SKEY='THSC' |
|
OletAndSkeySksw |
类型 = 'olet' AND SKEY='SKSW' |
|
OletAndSkeyLikeNi* |
类型 = 'olet' AND SKEY LIKE 'NI*' |
|
ElbowAndCompAtt1Sr |
类型='弯头'AND [COMPONENT-ATTRIBUTE1]='SR' |
|
InsulationAndTracingSpecNull |
类型 = 'INSULATION-SYMBOL' AND [TRACING-SPEC] IS NULL |
|
InsulationAndTracingSpecNotNull |
类型 = 'INSULATION-SYMBOL' AND NOT [TRACING-SPEC] IS NULL |
|
LocationPoint |
类型 = 'LOCATION-POINT' |
|
消息 |
类型 = 'MESSAGE' |
|
MessageSquare |
类型 = 'MESSAGE-SQUARE' |
|
MessageCircle |
类型 = 'MESSAGE-CIRCLE' |
|
MessageRound |
类型 = 'MESSAGE-ROUND' |
|
MessageHexa |
类型 = 'MESSAGE-POINTED' |
|
MessageTriangle |
类型 = 'MESSAGE-TRIANGLE' |
|
MessageDiamond |
类型 = 'MESSAGE-DIAMOND' |
|
MessageCCircle |
类型 = 'MESSAGE-DOUBLE-CIRCLE' |
|
MessageEllipse |
类型 = 'MESSAGE-ELLIPSE' |
|
BIPIDENTIFIER |
类型 = 'BIP-IDENTIFIER' |
|
PartFitting |
类型 NOT LIKE '*Weld' AND 类型 <> 'EndConnection' AND 类型 NOT LIKE 'END-*' AND 类型 <> 'PIPE' AND 类型 <> 'FLANGE' AND 类型 <> 'GASKET' AND 类型 <> 'BOLT' AND TYPE <> 'INSTRUMENT' |
|
PartFittingAndInstrument |
类型 NOT LIKE '*Weld' AND 类型 <> 'EndConnection' AND 类型 NOT LIKE 'END-*' AND 类型 <> 'PIPE' AND 类型 <> 'FLANGE' AND 类型 <> 'GASKET' AND 类型 <> 'BOLT' |
|
ValveOperatorSkewed |
类型 = 'VALVE' AND NOT （DIRECTION IS NULL OR DIRECTION='U'OR DIRECTION='D'OR DIRECTION='E'OR DIRECTION='N'OR DIRECTION='S'OR DIRECTION='W'） |
|
ValveOperatorPrimary |
类型 = 'VALVE' AND （DIRECTION='U'OR DIRECTION='D'OR DIRECTION='E'OR DIRECTION='N'OR DIRECTION='S'OR DIRECTION='W'） |
|
ValveOperatorU |
类型 = 'VALVE' AND DIRECTION='U' |
|
ValveOperatorD |
类型 = 'VALVE' AND DIRECTION='D' |
|
ValveOperatorW |
类型 = 'VALVE' AND DIRECTION='W' |
|
ValveOperatorE |
类型 = 'VALVE' AND DIRECTION='E' |
|
ValveOperatorS |
类型 = 'VALVE' AND DIRECTION='S' |
|
ValveOperatorN |
类型 = 'VALVE' AND DIRECTION='N' |
|
仪器 |
类型 = 'INSTRUMENT' |
|
TapConnection |
类型 = 'TAP-CONNECTION' |
|
ReducerEcc |
类型 = 'REDUCER-ECCENTRIC' |
|
PipeElbowTeeOrCross |
类型 = '管道' OR 类型 = '弯头' OR TYPE = '三通' OR 类型 =“四通” |
|
NotPipeElbowTeeOrCross |
NOT （类型 = '管道' OR 类型 = '弯头' OR TYPE = '三通' OR 类型 = '四通'） |
|
FlangeOrGasket |
类型 LIKE '法兰*' OR TYPE = 'Gasket' |
|
AnnoMsgInsulationOrFlowArrow |
类型 LIKE '注释*' OR 类型 LIKE '消息*' OR 类型 = 'INSULATION-SYMBOL' OR 类型 = 'FLOW-ARROW' |
|
WeldLayer |
类型 LIKE '*焊接' OR 类型 = '螺纹' OR SchemeName = 'FieldWeld' OR SchemeName = 'FieldFitWeld' |
|
尺寸 |
类型 = '尺寸' OR 类型 = 'AngDimension' |
|
扭曲 |
类型 = '倾斜' |
|
表 |
类型 =“表” |
|
WeldEnd1NullOrBw |
类型 LIKE '*Weld' AND （End1 IS NULL OR End1 = 'BW'） |
|
CompAttr1DrAvCvOrRv |
[COMPONENT-ATTRIBUTE1] = 'DR' OR [COMPONENT-ATTRIBUTE1] = 'AV' OR [COMPONENT-ATTRIBUTE1] = 'CV' OR [COMPONENT-ATTRIBUTE1] = 'RV' |
|
ValveCompAtt1AvCvOrRv |
类型 = 'VALVE' AND （[COMPONENT-ATTRIBUTE1] = 'AV' OR [COMPONENT-ATTRIBUTE1] = 'CV' OR [COMPONENT-ATTRIBUTE1] = 'RV'） |
|
ValveCompAtt1Dr |
类型 = 'VALVE' AND [COMPONENT-ATTRIBUTE1] = 'DR' |
|
ContinuationConnectionPiping |
类型 LIKE 'END-*' OR 类型 = 'EndConnection' |
|
EndPositionNull |
类型 = 'END-POSITION-NULL' |
|
EndConnectionsEquipment |
类型 = 'END-CONNECTION-EQUIPMENT' |
|
EndConnectionsPipe |
类型 = 'END-CONNECTION-PIPELINE' |
|
EndConnectonsOpen |
类型 = 'END-POSITION-OPEN' |
|
EndConnectionsClosed |
类型 = 'END-POSITION-CLOSED' |
|
EndConnectionsVent |
类型 = 'END-POSITION-VENT' |
|
EndConnectionsDrain |
类型 = 'END-POSITION-DRAIN' |
|
EndConnectionsToRefNotNull |
类型 = 'EndConnection' AND NOT [REFERENCE-TO] IS NULL |
|
EndConnectionsFromRefNotNull |
类型 = 'EndConnection' AND NOT [REFERENCE-FROM] IS NULL |
|
NotAnnoMsgInsulationOrFlowArrow |
NOT （类型 LIKE '注释*' OR 类型 LIKE '消息*' OR 类型 = 'INSULATION-SYMBOL' OR 类型 = 'FLOW-ARROW'） |