| 2 |
rsolanki |
1 |
/* App 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 USERS usr,
|
|
|
15 |
USER_APPLICATIONS usra
|
|
|
16 |
WHERE usra.USER_ID = usr.USER_ID
|
|
|
17 |
AND usra.APP_ID = :APP_ID
|
|
|
18 |
AND (
|
|
|
19 |
( /* Full name filter */
|
|
|
20 |
( LOWER( usr.FULL_NAME ) LIKE LOWER( :FULL_NAME ) AND NOT :FULL_NAME IS NULL ) OR
|
|
|
21 |
( usr.FULL_NAME = usr.FULL_NAME AND :FULL_NAME IS NULL )
|
|
|
22 |
)
|
|
|
23 |
OR ( /* Username filter */
|
|
|
24 |
( LOWER( usr.USER_NAME ) LIKE LOWER( :USER_NAME ) AND NOT :USER_NAME IS NULL ) OR
|
|
|
25 |
( usr.USER_NAME = usr.USER_NAME AND :USER_NAME IS NULL )
|
|
|
26 |
)
|
|
|
27 |
OR ( /* Domain filter */
|
|
|
28 |
( LOWER( usr.DOMAIN ) LIKE LOWER( :DOMAIN_NAME ) AND NOT :DOMAIN_NAME IS NULL ) OR
|
|
|
29 |
( usr.DOMAIN = usr.DOMAIN AND :DOMAIN_NAME IS NULL )
|
|
|
30 |
)
|
|
|
31 |
)
|
|
|
32 |
ORDER BY UPPER(usr.FULL_NAME)
|