Hi everyone!
I have a checkbox item on my application
and when i edit a row of my report i need it to populate my checkbox.
How can i do it?
Example below:
I have the rows TESTE_MENU, they belong to these 3 'Módulo' (Global, Portal Cidadão, Ouvidoria)
When i click edit i have a checkbox item that i need to be checked with the 3 'módulo'
in this case Global, Portal Cidadão and Ouvidoria.
How can i do it?
this is the query for values on my checkbox:
select STRNOME display_value,
ID return\_value from MODULO
where BLNATIVO = 1;
and in the report the query is:
SELECT ID_MENU,
STRNOME,
MENU\_DESCRICAO,
MENU\_USUARIO,
MENU\_ATUALIZACAO,
(SELECT M.STRNOME FROM MODULO M WHERE M.ID = FKEMODULO) MODULO,
CASE
WHEN MENU\_INATIVO IS NOT NULL THEN 'Inativo'
ELSE 'Ativo'
END
DTMINATIVO,
ID\_MODULOMENU,
FKEMODULO
FROM VW_MENU;
I'm using Oracle Apex 5.1 and Oracle Database 11g XE