test

test.sql

SELECT 
  CASE 
    WHEN get_userinfo('username') = 'william' THEN appl_id
    WHEN get_userinfo('username') = 'jimmy' THEN CONCAT(SUBSTRING(appl_id, 1, LENGTH(appl_id) - 6), 'XXXXXX')
    ELSE appl_id
  END AS appl_id
FROM ods_report
WHERE unit_code = (
  SELECT 
    CASE 
      WHEN get_userinfo('username') = 'william' THEN 'a'
      WHEN get_userinfo('username') = 'jimmy' THEN 'b'
      ELSE unit_code
    END
  FROM ods_report
);

您可以使用以下 SQL 語法來滿足您的需求：

SELECT 
  CASE 
    WHEN get_userinfo('username') = 'william' THEN appl_id
    WHEN get_userinfo('username') = 'jimmy' THEN CONCAT(SUBSTRING(appl_id, 1, LENGTH(appl_id) - 6), 'XXXXXX')
    ELSE appl_id
  END AS appl_id
FROM ods_report
WHERE 
  (get_userinfo('username') = 'william' AND unit_code = 'a') OR
  (get_userinfo('username') = 'jimmy' AND unit_code = 'b') OR
  (get_userinfo('username') NOT IN ('william', 'jimmy'));