Name: Structure Slab Thickness
Description: Thickness
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: Thickness
SQL Query:
SELECT coalesce(s.Thickness, slt.Thickness) Thickness
FROM SPSSlabEntity se
LEFT JOIN XLayerComposition rlc ON rlc.oidorigin = se.oid
JOIN JUASlabLayerType s ON s.oid = rlc.oiddestination /* layer in the model */
LEFT JOIN XSlabLayerTypeReferenceRln rslt ON rslt.oidorigin=rlc.oiddestination
JOIN JUASlabLayerType slt ON slt.oid= rslt.oiddestination /* layer in the catalog
*/
WHERE se.oid = ?