Select One and Select Many Item Types in Oracle APEX 24.1
Вставка
- Опубліковано 15 жов 2024
- We can use ‘select one’, ‘select many’ item type when selecting the department,
The difference between ‘select one’ and ‘select many’ is ‘select many’ can choose many options and return multiple values, while ‘select one’ can only select one value once a time. Select many has two types of ‘multiple values’ return, Delimited List and JSON Array
Delimited List example: ["10","20","30"]
JSON Array 10:20:30
So,when we change the page item P3_DEPTNO, The report will refresh, The Report SQL is:
select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO DEPT,
HOMEPAGE,
PROFILE
from EMP
/********************select one ******************/
-- where deptno = :P3_DEPTNO or :P3_DEPTNO is null
/********************select many delimited list *****************/
-- where deptno in (select column_value from apex_string.split ( :P3_DEPTNO, ':' )) or :P3_DEPTNO is null
/***************************select many JSON Array ************************/
where deptno in (
select
element
from
json_table ( :P3_DEPTNO, '$[*]'
columns
element varchar2 path '$'
)) or :P3_DEPTNO is null
Hello weili, Suppose If i want select all from select many item option then what I have to change in query ?
Good work.
Thank you! Cheers!
Thank you Weili Liu!!! You've helped me a lot!!!
Thank you Weili Liu!!!
Can you help me I want to know how to integrate oracle apex with technoriverstudio?
I will see and try. Thanks
Thank You Please u can explain about all the new features kindly
I’ll prepare for it