Comment afficher un champ de type ressource de l'annuaire (CN/DN) multivalués dans une colonne de vue
SELECT
FG.id_document as id,
FG.Nom_Groupe as Nom_Groupe,
FG.Description as Description,
Membres = substring( ( SELECT ',' + isnull(DR.cn_name,FG2.value) as [text()]
FROM
FRM_AMM_Diffusion_Group_FLD_Membres FG2
inner join DirectoryResources DR on DR.dn_name = FG2.value
WHERE
FG2.id_document = FG.id_document
FOR XML path(''), elements ), 2, 1000 ) ,
FG.Actif as Actif
FROM
FRM_AMM_Diffusion_Group FG
where
FG.id_document in (SELECT id_document FROM DocumentAccessView WHERE resource_name {0})