Custom query identity not available in the data picker

Hi,

I am unsure why the MySQL query below, whilst works and insert into DB without any errors, doesn’t output the two values when testing in Server Action? the vrfyCode_code and vrfyCode_key insert in DB, but don’t show their values in the Server Action so I can use then in the App connect side.

INSERT INTO users_codes
(vrfyCode_usr_id, vrfyCode_code, vrfyCode_key, vrfyCode_created)
VALUES (:P1, LPAD(FLOOR(RAND() * 999999.99), 4, '0'), (SELECT UUID()), :P3)

Screen Shot 2021-08-20 at 3.15.50 pm1694×1540 195 KB