Name: Piping Valve Operator Type
Description: Valve Operator type
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties:
SQL Query:
SELECT vot.Shortstringvalue as ValveOperatorType
FROM JDPipeComponent2 pc2
JOIN CL_ValveOperatorType vot ON vot.valueid=pc2.ValveOperatorType
JOIN Xmadefrom rmf ON (rmf.oiddestination = pc2.oid)
WHERE rmf.oidorigin = ?