Home/afzal/Best Answers
  1. Asked:

    Display Interactive Report for different roles sql query

    afzal

    afzal

    • India
    View Profile
    afzal Guru

    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)

    See less
    • 0
  2. Asked:

    Create Row Button to update table and set value of page item

    afzal

    afzal

    • India
    View Profile
    afzal Guru

    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 less
    • 0
  3. Asked:

    How to create time duration item in Oracle APEX?

    afzal

    afzal

    • India
    View Profile
    afzal Guru

    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 --
    PARENT ITEM-- P115_START_TIME

    See less
    • 2