| 119 |
ghuddy |
1 |
/* Application User List*/
|
|
|
2 |
SELECT DECODE ( usr.IS_ONLINE,
|
|
|
3 |
NULL, NULL,
|
|
|
4 |
'<img src="images/i_online.gif" title="User is online at '|| usr.ONLINE_AT ||'" width="16" height="16" border="0" hspace="2">' ) AS user_online,
|
|
|
5 |
DECODE ( usr.IS_DISABLED,
|
|
|
6 |
NULL, 'LIMG_USER',
|
|
|
7 |
'LIMG_USER_DISABLED' ) AS user_image,
|
|
|
8 |
usr.user_id,
|
|
|
9 |
usr.full_name,
|
|
|
10 |
usr.USER_EMAIL,
|
|
|
11 |
usr.USER_NAME,
|
|
|
12 |
usr.DOMAIN,
|
|
|
13 |
usr.LAST_REQUEST
|
|
|
14 |
FROM (
|
|
|
15 |
SELECT usr.*
|
|
|
16 |
FROM USERS usr,
|
|
|
17 |
USER_APPLICATIONS ua
|
|
|
18 |
WHERE ua.USER_ID = usr.USER_ID
|
|
|
19 |
AND ua.APP_ID = :APP_ID
|
|
|
20 |
) usr
|
|
|
21 |
WHERE(
|
|
|
22 |
( /* Full name filter */
|
|
|
23 |
( LOWER( usr.FULL_NAME ) LIKE LOWER( :FULL_NAME ) AND NOT :FULL_NAME IS NULL ) OR
|
|
|
24 |
( usr.FULL_NAME = usr.FULL_NAME AND :FULL_NAME IS NULL )
|
|
|
25 |
)
|
|
|
26 |
OR ( /* Username filter */
|
|
|
27 |
( LOWER( usr.USER_NAME ) LIKE LOWER( :USER_NAME ) AND NOT :USER_NAME IS NULL ) OR
|
|
|
28 |
( usr.USER_NAME = usr.USER_NAME AND :USER_NAME IS NULL )
|
|
|
29 |
)
|
|
|
30 |
OR ( /* Domain filter */
|
|
|
31 |
( LOWER( usr.DOMAIN ) LIKE LOWER( :DOMAIN_NAME ) AND NOT :DOMAIN_NAME IS NULL ) OR
|
|
|
32 |
( usr.DOMAIN = usr.DOMAIN AND :DOMAIN_NAME IS NULL )
|
|
|
33 |
)
|
|
|
34 |
)
|
|
|
35 |
AND usr.USER_ID NOT IN
|
|
|
36 |
(SELECT USER_ID FROM MEMBERS_GROUP WHERE GROUP_EMAIL_ID IN
|
|
|
37 |
(SELECT GROUP_EMAIL_ID
|
|
|
38 |
FROM AUTOBUILD_FAILURE
|
|
|
39 |
WHERE VIEW_ID = :VIEW_ID
|
|
|
40 |
AND PROJ_ID = :PROJ_ID
|
|
|
41 |
)
|
|
|
42 |
)
|
|
|
43 |
|
|
|
44 |
|
|
|
45 |
ORDER BY UPPER(usr.FULL_NAME)
|