Subversion Repositories DevTools

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

/* User List*/
SELECT 'User_General.asp' AS file_name,
           DECODE ( usr.IS_DISABLED,
                                NULL, 'IMG_USER',
                                'IMG_USER_DISABLED' ) AS item_image,
           usr.user_id AS item_id,
           usr.full_name ||' ['|| usr.user_name ||']' AS item_name,
           'user_id='|| usr.user_id AS param
  FROM USERS usr 
ORDER BY UPPER(usr.FULL_NAME)