Tension des manchons et coffrets

[ponceta]

Pour caractériser géographiquement la tension d'un manchon contenu dans une chambre, il faut aller récupérer le niveau de tension d'un de ses composants.

Inspiration :

Chambre (noeud)
-\ Manchon (enfant du noeud)
-- \ Point de connexion ou borne (composant enfant de l'enfant du noeud)

SELECT
	obrv.id_obrv as id_obrv,
	obrv.idobr_obrv as id_obr,
	obrv.idorc_obrv as id_orc,
	obrv.modele_obrv AS modele,
	obrv.code_obrv AS code,
	obrv.nom_obrv as nom,
	v_obrvl.id_obrv as id_obrv,
	v_obrvl.idobr_obrv as id_obr,
	--v_obrvl.modele_obrv AS modele,
	--v_obrvl.code_obrv AS code,
	v_obrvl.nom_obrv as nom,
	copv.idniv_copv as tension,
	obrv_enf.id_obrv as id_obrv_enf,
	obrv_enf.idobr_obrv as id_obr_enf,
	obrv_enf.modele_obrv AS modele_enf,
	obrv_enf.code_obrv AS code_enf,
	obrv_enf.nom_obrv as nom_enf,
	obrv_enf.idorc_obrv as id_orc_enf

FROM dbo.objetreseauversion_obrv obrv
	LEFT JOIN dbo.v_objetreseauversionliaison v_obrvl  ON v_obrvl.idparent_cmp = obrv.id_obrv
	LEFT JOIN dbo.composantversion_copv copv ON copv.id_obrv = v_obrvl.id_obrv
	LEFT JOIN dbo.objetreseauversion_obrv obrv_enf ON obrv_enf.id_obrv = copv.id_obrv
	
WHERE obrv.idorc_obrv = 13
AND copv.idniv_copv  != 5
	--AND obrv.idprj_obrv != 1 
	--AND ndfv.idprj_ndfv != 1; -- manchons