Name: Electrical Cable Impedance
Description: Cable Impedance Rating
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: Impedance
SQL Query:
SELECT cabcap.Impedance AS Impedance
FROM JRteCableRun cabrun
LEFT JOIN XSpecifiedCable cabs ON cabs.oidOrigin = cabrun.oid
LEFT JOIN JCablePart cabprt ON cabprt.oid = cabs.oiddestination
LEFT JOIN JCableCapacity cabcap ON cabcap.oid = cabprt.oid
WHERE cabrun.oid = ?