Name: Electrical Cable Power
Description: Cable Power Rating
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: PowerCapacity
SQL Query:
SELECT cabcap.PowerCapacity AS PowerCapacity
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 = ?