Bonjour,

Ci joint le SQL généré avec 360view pour un repo Oracle

SELECT
DOCUMENTS_MAIL.M_DOC_C_NAME,
TRANSIT_DOMAIN_DOC.M_REPO_C_NAME,
decode(DOCUMENTS_MAIL.M_DOC_N_TYPE,'0','Documentation (doc, pdf, ppt ...)','1','BusinessObjects document .rep','8','List of values','128','Webi 5 document .wqy','1024','Webi 6 document .wid','512','Documentation (doc, pdf, ppt ...)','2','Script','4','document sent to Broadcast Agent (after first
processing)','32','BusinessQuery document','64','Compiled script','16','Template','256','Add-in .rea','Unknown type'),
to_date('12/15/1970','MM/DD/YYYY') + (DOCUMENTS_MAIL.M_DOC_N_DATE/86400),
( OBJ_M_ACTOR.M_ACTOR_C_NAME ),
EXPORTATEUR_DOC.M_ACTOR_C_NAME,
decode(OBJ_M_ACTORLINK.M_ACTL_N_ACTORTYPE,'32','BCA document','Document sent between users')
FROM
OBJ_M_DOCUMENTS DOCUMENTS_MAIL,
OBJ_M_REPOSITORY TRANSIT_DOMAIN_DOC,
OBJ_M_ACTOR,
OBJ_M_ACTOR EXPORTATEUR_DOC,
OBJ_M_ACTORLINK,
OBJ_M_ACTORDOC
WHERE
( OBJ_M_ACTOR.M_ACTOR_N_ID=OBJ_M_ACTORLINK.M_ACTL_N_ACTORID )
AND ( OBJ_M_ACTOR.M_ACTOR_N_ID=OBJ_M_ACTORDOC.M_ACTDC_N_ACTORID )
AND ( DOCUMENTS_MAIL.M_DOC_N_ID=OBJ_M_ACTORDOC.M_ACTDC_N_DOCID )
AND ( EXPORTATEUR_DOC.M_ACTOR_N_ID=DOCUMENTS_MAIL.M_DOC_N_USERID )
AND ( DOCUMENTS_MAIL.M_DOC_N_PERSISTENT=0 )
AND ( TRANSIT_DOMAIN_DOC.M_REPO_N_ID=DOCUMENTS_MAIL.M_DOC_N_REPOID and TRANSIT_DOMAIN_DOC.M_REPO_N_TYPE=3 )
AND ( OBJ_M_ACTOR.M_ACTOR_N_LAT<>1 )
AND ( OBJ_M_ACTORLINK.M_ACTL_N_LAT<>1 )


Cdlt
Sébastien Goiffon
http://www.gbandsmith.com