1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
select *
from
co_fld_dossier_sp dossier,
co_fld_comite_sp comite,
co_doc_odj_sp odj,
dbo.dm_sysobject_r odj_r,
co_fld_dossier_rp dm_repeating1_0
where ((comite.r_object_id=dossier.co_nom_comite_dossier)
and (odj_r.i_folder_id=comite.r_object_id)
and (odj.r_object_id=odj_r.r_object_id)
and dm_repeating1_0.r_object_id=dossier.r_object_id
and (comite.co_typ_comite=N'CCG')
and (comite.co_dat_comite>= convert(datetime, '01/11/2008 0:0:0', 103))
and (dossier.co_top_confidentiel=N'N'))
and (dossier.i_has_folder = 1 and dossier.i_is_deleted = 0)
and (comite.i_has_folder = 1 and comite.i_is_deleted = 0)
and (
(dossier.owner_name in ('DARAI','dm_world','reporting','rol_creation_repo','rol_admin','rol_creation_doss','rol_creation_comi','administrateur'))
or (exists(select 1 from dm_acl_s ACL_S, dm_acl_r ACL_R
where ACL_S.r_object_id = ACL_R.r_object_id and ossier.acl_domain = ACL_S.owner_name and dossier.acl_name = ACL_S.object_name and ((ACL_R.r_accessor_name in ('DARAI','dm_world') or (ACL_R.r_is_group = 1 and (ACL_R.r_accessor_name in ('DARAI','dm_world','reporting','rol_creation_repo','rol_admin','rol_creation_doss','rol_creation_comi','administrateur'))))
and ((ACL_R.r_permit_type = 0 or ACL_R.r_permit_type is null)
and (((ACL_R.r_accessor_permit >= 2))))))))
and ((comite.owner_name in ('dm_world','DARAI','reporting','rol_creation_repo','rol_admin','rol_creation_doss','rol_creation_comi','administrateur'))
or (exists(select 1 from dm_acl_s ACL_S, dm_acl_r ACL_R where ACL_S.r_object_id = ACL_R.r_object_id and comite.acl_domain = ACL_S.owner_name and comite.acl_name = ACL_S.object_name and (( ACL_R.r_accessor_name in ('DARAI','dm_world') or (ACL_R.r_is_group = 1 and (ACL_R.r_accessor_name in ('DARAI','dm_world','reporting','rol_creation_repo','rol_admin','rol_creation_doss','rol_creation_comi','administrateur')))) and ( (ACL_R.r_permit_type = 0 or ACL_R.r_permit_type is null) and (((ACL_R.r_accessor_permit >= 2)))))))) and ((odj.owner_name in('DARAI','dm_world','reporting','rol_creation_repo','rol_admin','rol_creation_doss','rol_creation_comi','administrateur')) or (exists(select 1 from dm_acl_s ACL_S, dm_acl_r ACL_R where ACL_S.r_object_id = ACL_R.r_object_id and odj.acl_domain = ACL_S.owner_name and odj.acl_name = ACL_S.object_name and ((ACL_R.r_accessor_name in ('DARAI','dm_world') or (ACL_R.r_is_group = 1 and (ACL_R.r_accessor_name in ('DARAI','dm_world','reporting','rol_creation_repo','rol_admin','rol_creation_doss','rol_creation_comi','administrateur')))) and ((ACL_R.r_permit_type = 0 or ACL_R.r_permit_type is null) and (((ACL_R.r_accessor_permit >= 2))))))))
order by 6 desc |
Partager