Filter expressions.
Refer to http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx for expression syntax.
|
Name |
Sample value: Tee |
|
Value |
Sample value: Type LIKE 'TEE*' |
| Name | Value |
|
Tee |
Type LIKE 'TEE*' |
|
Cross |
Type LIKE 'CROSS*' |
|
Support |
Type='Support' |
|
FieldFitWeld |
Type='FieldFitWeld' |
|
ReducerLike |
Type LIKE 'Reducer*' |
|
FlangeLike |
Type LIKE '*FLANGE' |
|
MsgDimensioned |
Type LIKE 'MESSAGE*' AND UNDIMENSIONED IS NULL |
|
ValveEndNotFlange |
Type = 'VALVE' AND (End1 <> 'FL' OR END2 <> 'FL') |
|
BWValve |
Type = 'VALVE' AND End1='BW' |
|
TWValve |
Type = 'VALVE' AND End1='TW' |
|
SWValve |
Type = 'VALVE' AND End1='SW' |
|
FLValve |
Type = 'VALVE' AND End1='FW' |
|
CPValve |
Type = 'VALVE' AND End1='CP' |
|
InlineBranch |
Type Like 'TEE*' OR Type Like 'CROSS' |
|
OletAndServiceDrAvCvOrRv |
Type='Olet' AND (Service = 'DR' OR Service = 'AV' OR Service = 'CV' OR Service = 'RV') |
|
Gasket |
Type='Gasket' |
|
Cap |
Type = 'CAP' |
|
BlindFlangeAndCaps |
Type='FLANGE-BLIND' OR Type='CAP' |
|
EndLike |
Type LIKE 'END-*' |
|
EndConnection |
Type = 'EndConnection' |
|
WeldFieldItem |
Type LIKE '*Weld' AND (Category='ERECTION-ITEM' OR Category='OFFSHORE-ITEM') |
|
WeldShopItem |
Type LIKE '*Weld' AND Category='FABRICATION-ITEM' |
|
Weld |
Type LIKE '*Weld' |
|
AnyItem |
Type LIKE '*' |
|
FieldItem |
Category='ERECTION-ITEM' OR Category='OFFSHORE-ITEM' |
|
ShopItem |
Category='FABRICATION-ITEM' |
|
Components |
(FieldItem AND (NOT Type='Weld')) OR (Type='Valve' AND End1='FL') OR (Type='Pipe' AND Length=MaxPipeLength) |
|
Components_MaxPipeLengthSegmentsAsSpools |
(FieldItem AND (NOT Type='Weld')) OR (Type='Valve' AND End1='FL') |
|
ItemCodeNotNull |
NOT [ITEM-CODE] IS NULL |
|
Pipe |
Type = 'Pipe' |
|
Flange |
Type = 'Flange' |
|
Fitting |
NOT (Type = 'Pipe' OR Type = 'Gasket' OR Type = 'Flange' OR Type = 'Bolt' OR Type = 'Valve' OR Type = 'Olet' OR Type = 'Instrument' OR Type = 'Support') |
|
FittingAndInstrument |
NOT (Type = 'Pipe' OR Type = 'Gasket' OR Type = 'Flange' OR Type = 'Bolt' OR Type = 'Valve' OR Type = 'Olet' OR Type = 'Support') |
|
Bolt |
Type = 'Bolt' |
|
Fastener |
Type ='Gasket' OR Type='Bolt' |
|
Valve |
Type = 'Valve' |
|
Olet |
Type = 'Olet' |
|
ItemCodeNotNullAndCategoryFabItem |
NOT [ITEM-CODE] IS NULL AND Category='FABRICATION-ITEM' |
|
ItemCodeNotNullAndCategoryErecItem |
NOT [ITEM-CODE] IS NULL AND Category='ERECTION-ITEM' |
|
ExistingFalseSpoolNumberNotEmpty |
Existing = 'false' AND SpoolNumber <> '' |
|
NotBoltOrWeld |
Type <> 'BOLT' AND Type NOT LIKE '*Weld' |
|
FieldWeld |
Type = 'FieldWeld' |
|
ReducerEccAndFlatDirectionDown |
Type = 'REDUCER-ECCENTRIC' AND [FLAT-DIRECTION]='DOWN' |
|
ReducerEccAndFlatDirectionUp |
Type = 'REDUCER-ECCENTRIC' AND [FLAT-DIRECTION]='UP' |
|
OletAndSkeyWtbw |
Type = 'olet' AND SKEY='WTBW' |
|
OletAndSkeyLascLaswOrLabw |
Type = 'olet' AND (SKEY='LASC' OR SKEY='LASW' OR SKEY='LABW') |
|
OletAndSkeyThsc |
Type = 'olet' AND SKEY='THSC' |
|
OletAndSkeySksw |
Type = 'olet' AND SKEY='SKSW' |
|
OletAndSkeyLikeNi* |
Type = 'olet' AND SKEY LIKE 'NI*' |
|
ElbowAndCompAtt1Sr |
Type='Elbow' AND [COMPONENT-ATTRIBUTE1]='SR' |
|
InsulationAndTracingSpecNull |
Type = 'INSULATION-SYMBOL' AND [TRACING-SPEC] IS NULL |
|
InsulationAndTracingSpecNotNull |
Type = 'INSULATION-SYMBOL' AND NOT [TRACING-SPEC] IS NULL |
|
LocationPoint |
Type = 'LOCATION-POINT' |
|
Message |
Type = 'MESSAGE' |
|
MessageSquare |
Type = 'MESSAGE-SQUARE' |
|
MessageCircle |
Type = 'MESSAGE-CIRCLE' |
|
MessageRound |
Type = 'MESSAGE-ROUND' |
|
MessageHexa |
Type = 'MESSAGE-POINTED' |
|
MessageTriangle |
Type = 'MESSAGE-TRIANGLE' |
|
MessageDiamond |
Type = 'MESSAGE-DIAMOND' |
|
MessageCCircle |
Type = 'MESSAGE-DOUBLE-CIRCLE' |
|
MessageEllipse |
Type = 'MESSAGE-ELLIPSE' |
|
BIPIDENTIFIER |
Type = 'BIP-IDENTIFIER' |
|
PartFitting |
Type NOT LIKE '*Weld' AND Type <> 'EndConnection' AND Type NOT LIKE 'END-*' AND Type <> 'PIPE' AND Type <> 'FLANGE' AND Type <> 'GASKET' AND Type <> 'BOLT' AND TYPE <> 'INSTRUMENT' |
|
PartFittingAndInstrument |
Type NOT LIKE '*Weld' AND Type <> 'EndConnection' AND Type NOT LIKE 'END-*' AND Type <> 'PIPE' AND Type <> 'FLANGE' AND Type <> 'GASKET' AND Type <> 'BOLT' |
|
ValveOperatorSkewed |
Type = '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 |
Type = 'VALVE' AND (DIRECTION='U' OR DIRECTION='D' OR DIRECTION='E' OR DIRECTION='N' OR DIRECTION='S' OR DIRECTION='W') |
|
ValveOperatorU |
Type = 'VALVE' AND DIRECTION='U' |
|
ValveOperatorD |
Type = 'VALVE' AND DIRECTION='D' |
|
ValveOperatorW |
Type = 'VALVE' AND DIRECTION='W' |
|
ValveOperatorE |
Type = 'VALVE' AND DIRECTION='E' |
|
ValveOperatorS |
Type = 'VALVE' AND DIRECTION='S' |
|
ValveOperatorN |
Type = 'VALVE' AND DIRECTION='N' |
|
Instrument |
Type = 'INSTRUMENT' |
|
TapConnection |
Type = 'TAP-CONNECTION' |
|
ReducerEcc |
Type = 'REDUCER-ECCENTRIC' |
|
PipeElbowTeeOrCross |
Type = 'Pipe' OR Type = 'Elbow' OR TYPE = 'Tee' OR Type = 'Cross' |
|
NotPipeElbowTeeOrCross |
NOT (Type = 'Pipe' OR Type = 'Elbow' OR TYPE = 'Tee' OR Type = 'Cross') |
|
FlangeOrGasket |
Type LIKE 'Flange*' OR TYPE = 'Gasket' |
|
AnnoMsgInsulationOrFlowArrow |
Type LIKE 'Annotation*' OR Type LIKE 'Message*' OR Type = 'INSULATION-SYMBOL' OR Type = 'FLOW-ARROW' |
|
WeldLayer |
Type LIKE '*Weld' OR Type = 'Thread' OR SchemeName = 'FieldWeld' OR SchemeName = 'FieldFitWeld' |
|
Dimension |
Type = 'Dimension' OR Type = 'AngDimension' |
|
Skew |
Type = 'Skew' |
|
Table |
Type = 'Table' |
|
WeldEnd1NullOrBw |
Type 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 |
Type = 'VALVE' AND ([COMPONENT-ATTRIBUTE1] = 'AV' OR [COMPONENT-ATTRIBUTE1] = 'CV' OR [COMPONENT-ATTRIBUTE1] = 'RV') |
|
ValveCompAtt1Dr |
Type = 'VALVE' AND [COMPONENT-ATTRIBUTE1] = 'DR' |
|
ContinuationConnectionPiping |
Type LIKE 'END-*' OR Type = 'EndConnection' |
|
EndPositionNull |
Type = 'END-POSITION-NULL' |
|
EndConnectionsEquipment |
Type = 'END-CONNECTION-EQUIPMENT' |
|
EndConnectionsPipe |
Type = 'END-CONNECTION-PIPELINE' |
|
EndConnectonsOpen |
Type = 'END-POSITION-OPEN' |
|
EndConnectionsClosed |
Type = 'END-POSITION-CLOSED' |
|
EndConnectionsVent |
Type = 'END-POSITION-VENT' |
|
EndConnectionsDrain |
Type = 'END-POSITION-DRAIN' |
|
EndConnectionsToRefNotNull |
Type = 'EndConnection' AND NOT [REFERENCE-TO] IS NULL |
|
EndConnectionsFromRefNotNull |
Type = 'EndConnection' AND NOT [REFERENCE-FROM] IS NULL |
|
NotAnnoMsgInsulationOrFlowArrow |
NOT (Type LIKE 'Annotation*' OR Type LIKE 'Message*' OR Type = 'INSULATION-SYMBOL' OR Type = 'FLOW-ARROW') |