Report with user and group

[Former Member]

Hi.

I'm looking for the way to make a report from the BO 6.5 repository that has the user and the group where he is registered.

Have someone done a query like this?

Thanks in advanced

[Former Member]

select usr.m_actor_c_name as USUARIO,B.M_ACTL_N_ACTORTYPE,

CASE WHEN b.M_ACTL_N_ACTORTYPE = 1 THEN 'COMPANY'

WHEN b.M_ACTL_N_ACTORTYPE = 2 THEN 'GENERAL SUPERVISOR'

WHEN b.M_ACTL_N_ACTORTYPE = 4 THEN 'SUPERVISOR'

WHEN b.M_ACTL_N_ACTORTYPE = 8 THEN 'DESIGNER'

WHEN b.M_ACTL_N_ACTORTYPE = 12 THEN 'SUPERVISOR DESIGNER'

WHEN b.M_ACTL_N_ACTORTYPE = 16 THEN 'USER'

WHEN b.M_ACTL_N_ACTORTYPE = 32 THEN 'DS'

WHEN b.M_ACTL_N_ACTORTYPE = 64 THEN 'VERSATILE'

WHEN b.M_ACTL_N_ACTORTYPE = 128 THEN 'CMDSETTING'

END AS NOMBRE,

usr_grps.m_actor_c_name as GRUPO

from obj_m_actor usr,

obj_m_actorlink usr_link1,

obj_m_actorlink usr_link2,

obj_m_actor usr_grps,

OBJ_M_ACTORLINK B

where usr_link1.m_actl_n_actorid = usr.m_actor_n_id

AND usr_link1.m_actl_n_fatlinkid = usr_link2.m_actl_n_id

AND usr_link2.m_actl_n_actorid = usr_grps.m_actor_n_id

AND usr.M_ACTOR_N_ID = B.M_ACTL_N_ACTORID

AND usr_link2.m_actl_n_lat != 1

AND usr_link1.m_actl_n_lat != 1

AND usr_link1.m_actl_n_actortype != 1

AND usr.m_actor_n_lat != 1

AND usr.m_actor_n_type != 1

AND UPPER(usr.M_ACTOR_C_NAME) LIKE 'MX%'

Edited by: Manuel Morales on May 21, 2009 11:31 PM