select id,column as title from form f,manager m,users u where f.mid=m.mid and u.id=m.id and where lower(u.username)=lower(:session_user_name) union all select id,column as title from form f,manager m,users u where f.mid=m.manid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
select id,column as title from form f,manager m,users u where f.mid=m.mid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
union all
select id,column as title from form f,manager m,users u where f.mid=m.manid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
I think , you should use 'id' instead of 'mid' at this below code only. JavaScript Expression: $(this.triggeringElement).parent().data('mid') correct-- JavaScript Expression: $(this.triggeringElement).parent().data('id');
I think , you should use 'id' instead of 'mid' at this below code only.
STEP 2-- CREATE SECOND ITEM "P115_END_TIME" AS SELECT LIST
QUERY-- select TO_CHAR(TO_DATE(:P115_START_TIME,'DD/MM/YYYY HH:MI AM') + (1/1440*(level-1)*15),'HH:MI AM')|| CASE WHEN (((level-1)*15))/60 >1 THEN CASE WHEN MOD(((level-1)*15),60)> 0 THEN '( '|| FLOOR((((level-1)*15))/60)||' HOURS '|| MOD(((level-1)*15),60)||' MINUTES )' ELSE '( '||(((level-1)*15))/60||' HOURS)' END ELSE CASE WHEN ((level-1)*15)=0 THEN '( 0 MINUTES )' ELSE CASE WHEN MOD(((level-1)*15),60) = 0 THEN '( 1 HOURS )' ELSE '( '||MOD(((level-1)*15),60)||' MINUTES )' END END END AS DD , ((level-1)*15) RR //--RETURN VALUE AS YOUR REQUIREMENT
from dual CONNECT BY LEVEL<97
Cascading List of Values -- PARENT ITEM-- P115_START_TIME
Display Interactive Report for different roles sql query
afzal
select id,column as title from form f,manager m,users u where f.mid=m.mid and u.id=m.id and where lower(u.username)=lower(:session_user_name) union all select id,column as title from form f,manager m,users u where f.mid=m.manid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
select id,column as title
from form f,manager m,users u
where f.mid=m.mid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
union all
select id,column as title
See lessfrom form f,manager m,users u
where f.mid=m.manid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
Create Row Button to update table and set value of page item
afzal
I think , you should use 'id' instead of 'mid' at this below code only. JavaScript Expression: $(this.triggeringElement).parent().data('mid') correct-- JavaScript Expression: $(this.triggeringElement).parent().data('id');
I think , you should use 'id' instead of 'mid' at this below code only.
JavaScript Expression: $(this.triggeringElement).parent().data('mid')
correct-- JavaScript Expression: $(this.triggeringElement).parent().data('id');
See lessHow to create time duration item in Oracle APEX?
afzal
STEP 1-- CREATE ITEM "P115_START_TIME" AS SELECT LIST QUERY-- select to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH:MI:SS') + (1/1440*(level-1)*15),'HH:MI AM') DISPLAY , to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH:MI:SS') + (1/1440*(level-1)*15),'DD/MM/YYYY HH:MI AM') RETURN_VAL fromRead more
STEP 1-- CREATE ITEM "P115_START_TIME" AS SELECT LIST
QUERY--
select to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH:MI:SS') + (1/1440*(level-1)*15),'HH:MI AM') DISPLAY ,
to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH:MI:SS') + (1/1440*(level-1)*15),'DD/MM/YYYY HH:MI AM') RETURN_VAL
from dual CONNECT BY LEVEL<97;
NOTE- Format Mask===>DD/MM/YYYY HH:MI AM
STEP 2-- CREATE SECOND ITEM "P115_END_TIME" AS SELECT LIST
QUERY--
select TO_CHAR(TO_DATE(:P115_START_TIME,'DD/MM/YYYY HH:MI AM') + (1/1440*(level-1)*15),'HH:MI AM')||
CASE WHEN (((level-1)*15))/60 >1 THEN
CASE WHEN MOD(((level-1)*15),60)> 0 THEN '( '|| FLOOR((((level-1)*15))/60)||' HOURS '|| MOD(((level-1)*15),60)||' MINUTES )'
ELSE '( '||(((level-1)*15))/60||' HOURS)'
END
ELSE
CASE WHEN ((level-1)*15)=0 THEN '( 0 MINUTES )'
ELSE
CASE WHEN MOD(((level-1)*15),60) = 0 THEN '( 1 HOURS )'
ELSE '( '||MOD(((level-1)*15),60)||' MINUTES )'
END
END
END AS DD ,
((level-1)*15) RR //--RETURN VALUE AS YOUR REQUIREMENT
from dual CONNECT BY LEVEL<97
Cascading List of Values --
See lessPARENT ITEM-- P115_START_TIME