Side Navigation
From Emprise Wiki
Contents
- 1 SAMM 1.0 Navigations
- 2 SAMM 2.0 Navigations
- 3 Navigation Type: Vessel Equipment
- 4 Navigation Type: Equipment
- 5 Navigation Type Personnel
- 6 Navigation Type: Findings
- 7 Navigation Type: Vessel
- 8 Navigation Type: Test Type
- 9 Navigation Type: Roles
- 10 Navigation Type: Certificate
- 11 Navigation Actions
Vessel - Vessel
Vessel - Class
Vessel - PM
Vessel - Hull
Hierarchy: System/ Description
Notes
- Tree is pulling from the table: SAMM.VesselsEquipmentSystems
- Empty Nodes are Not Displayed
- My Items node shall be added in the Feedback module. Click here for documentation.
Example SQL to build Navigation Tree Conceptually SELECT 'ALL Vessels' as "Root Node", Vessels.VesselName as "Node 1", EquipmentSystems.EquipmentSystemDescription as "Node 2", EquipmentClassifications.EquipmentClassificationDescription as "Node 3", VesselEquipmentDesc as Leaf, SUM(VesselEquipmentIsActive) as NumberofSourceEquipmentforMainGridRecords FROM SAMM.Vessels JOIN SAMM.VesselsEquipment JOIN SAMM.VesselsEquipmentSystems JOIN -- Note this limits the Displayed Systems and Descriptions to what is on the vessel(s) SAMM.EquipmentSystems JOIN SAMM.EquipmentClassifications JOIN SAMM.VesselsEquipmentLocations -- This Join limits the equipment that has Locations to ensure we are not just displaying HSC Placeholders WHERE VesselEquipmentIsActive = 1 AND VesselsEquipment.OperationalStatusId is not null -- This Join limits the equipment that has OperationStatusId to ensure we are not just displaying HSC Placeholders GROUP BY Vessels.VesselName, SAMM.EquipmentSystems.EquipmentSystemDescription, SAMM.EquipmentClassifications.EquipmentClassificationDescription, VesselEquipmentDesc WITH ROLLUP ORDER BY Vessels.VesselName, EquipmentSystems.EquipmentSystemDescription, EquipmentClassifications.EquipmentClassificationDescription, VesselEquipmentDesc |
Hierarchy: Description
Hierarchy: Equipment HSC
Hierarchy: Location
Hierarchy: Test Type
Hierarchy: System/ Description
Hierarchy: Description
Hierarchy: Equipment HSC
Hierarchy: Description / Model
Nav. Type
Equipment
Description / Model | |||
Tree Definition | |||
Node | Example | Qualifier | |
---|---|---|---|
Root Node | (All) | All Vessels | (null) |
Node 1 | |||
Node 2 | |||
Node 3 | |||
Leaf | |||
Main Grid Data | |||
Notes
| |||
Example SQL to build Navigation Tree Conceptually Insert Example Here Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. |
Hierarchy: Manufacturer / Model
Hierarchy: Description / Sub-Description
Hierarchy: Test Type
Hierarchy: Billet
Hierarchy: Finding Against
Hierarchy: Procedure by Name
Hierarchy: Procedure by Number
Hierarchy: FORAC
Hierarchy: PM
Hierarchy: Class
Hierarchy: PM / Class
Hierarchy: A–Z
Hierarchy: Vessel Equipment
Hierarchy: Module
Hierarchy: Submodule (Case Study)
Hierarchy: Vessel
Notes
- Empty Nodes are Not Displayed
Example SQL to build Navigation Tree Conceptually Insert Example Here Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. |