APEX

Hi,

Under Oracle APEX 24.2.10 on page 17 of application 108, the item of a a table P17_MISSION is a LOV select. But instead of returning as display the dispaly value D, it shows the IDs of the MISSION :

The select values of this item is made with a sql request on this element :

select ap.id      as r, 
      p.titre_mission as D
 from ad_gestion_projet ap
 join ad_projet         p
   on ap.id = p.id;

But, if i try this select on the SQL commands, I get results :

I have tried many times with a LOV definition “Toutes les missions” with the same select. And tried also SQL resquest for the lov values of the item P17_MISSION but I get the same results.

Best regards.