Overview
This command will list the teams of which a certain user is a member. The teams of which the user is a member due to their department and/or position will be listed as well.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
ADTEAMUSER
|
Stores the relationship between team and users
|
CDTEAM
CDUSER
|
ADALLUSERS
ADTEAM
|
ADTEAM
|
Stores teams
|
CDTEAM
|
ADAUTHLDAPCONFIG
GNMAPPING
GNPERMISSION
|
ADALLUSERS
|
Stores uses
|
CDUSER
|
ADALLUSERS
ADUSEREXTERNALDATA
GNFAVORITE
|
Oracle/Postgres/SQL Server
SELECT
ADT.NMTEAM
FROM ADTEAMUSER ADTU
INNER JOIN ADTEAM ADT ON (ADTU.CDTEAM = ADT.CDTEAM)
INNER JOIN ADALLUSERS ADU ON (ADTU.CDUSER = ADU.CDUSER)
WHERE ADU.IDUSER = 'MATRICULA_DO_USUARIO' AND ADT.CDISOSYSTEM <> 999 AND FGENABLED <> 3; /* OBS 1 */
|
Notes
▪NOTE1: User ID to be filtered in the search.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
NMTEAM
|
VARCHAR (255)
|
Team name
|
|