Hi. I am using Oracle APEX 22.1.1.
I have two items P1_PATIENT_NAME which is a text field with autocomplete and P1_PATIENT_ID. I created an onChange dynamic action on P1_PATIENT_NAME to get the ID of the name entered by the user (not the contrary). P1_PATIENT_NAME is based on a unique column. The DA is of type "set value" and "set type" is "SQL Statement". The query is...
"select id from patient where name = :P1_PATIENT_NAME and doctor_id = 1". The query retrieves data in "SQL Commands". I tried retrieving a static value from dual like "select 22 from dual" and it did not work too. Affected elements = P1_PATIENT_ID. Page items to submit = P1_PATIENT_NAME. Am I missing something here?