Home/ /Answers
  1. Asked: November 29, 2020

    Multiple validations in dynamic action

    suppose your item is p1_item1, p1_item2 validation-- PL/SQL Function Body Returning Error Text begin if :p1_item1 is null and :p1_item2 is null then return 'both item should not empty'; elsif :p1_item1 is null and :p1_item2 is not null then return 'p1_item1 should not empty'; elsif :p1_item2 is nullRead more

    suppose your item is p1_item1, p1_item2
    validation– PL/SQL Function Body Returning Error Text

    begin
    if :p1_item1 is null and :p1_item2 is null then
    return ‘both item should not empty’;
    elsif :p1_item1 is null and :p1_item2 is not null then
    return ‘p1_item1 should not empty’;
    elsif :p1_item2 is null and :p1_item1 is not null then
    return ‘p1_item2 should not empty’;
    end if;
    end;
    —replace error message as your requirement
    Always Execute===> yes

    See less
  2. Asked: November 30, 2020

    Bi Publisher Report: Single query, Multiple Layouts

    @Vinish Please Help me.

    @Vinish Please Help me.

    See less
  3. Asked: November 29, 2020

    How to make filed as Read only through java script

    Thanks, It's working. Can we do the same for sub Region, for example, i have to change caption of Static Conent but no luck.   can you please suggest some idea.

    Thanks,

    It’s working.

    Can we do the same for sub Region, for example, i have to change caption of Static Conent but no luck.

     

    can you please suggest some idea.

    See less
  4. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    Hi pavlos, are you using plugging for nested report ?      

    Hi pavlos,

    are you using plugging for nested report ?

     

     

     

    See less
  5. Asked: November 29, 2020

    How to make filed as Read only through java script

    keep the following css property at the "advanced" section of the item Custom Attributes==> style="pointer-events: none;"

    keep the following css property
    at the “advanced” section of the item
    Custom Attributes==> style=”pointer-events: none;”

    See less
  6. Asked: November 30, 2020

    Bi Publisher Report: Single query, Multiple Layouts

    APEX_UTIL.GET_PRINT_DOCUMENT ( p_report_data IN CLOB, p_report_layout IN CLOB, p_report_layout_type IN VARCHAR2 default 'xsl-fo', p_document_format IN VARCHAR2 default 'pdf', p_print_server IN VARCHAR2 default NULL) RETURN BLOB; Try it.

    APEX_UTIL.GET_PRINT_DOCUMENT (
    p_report_data         IN CLOB,
    p_report_layout       IN CLOB,
    p_report_layout_type  IN VARCHAR2 default 'xsl-fo',
    p_document_format     IN VARCHAR2 default 'pdf',
    p_print_server        IN VARCHAR2 default NULL)
RETURN BLOB;
Try it.
    See less
  7. Asked: November 13, 2020

    Show value from database link on oracle apex 20

    Hi Vinish, I find a way to solve my problem on Apex. On DB, I create view by <code> materialized  view refresh force on demand start with </code> And when I run on select list of page item, it shows me value.

    Hi Vinish, I find a way to solve my problem on Apex.

    On DB, I create view by

    <code>

    materialized  view refresh force on demand start with

    </code>

    And when I run on select list of page item, it shows me value.

    See less
  8. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    This answer was edited.

    Thanks a lot! It works for parent region, but doesn't work for nested child region. I would like to disable hover, background color is changed to default when mouse is over highlighted row

    Thanks a lot!

    It works for parent region, but doesn’t work for nested child region.

    I would like to disable hover, background color is changed to default when mouse is over highlighted row

    See less
  9. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    step -1 give class name for your report like-- emp at report region , appearance section "CSS Classes" => emp step -2 create a dynamic action at page load action == execute javascript code like-- //-- replace your conditional column with "DEPTNO", AND ALSO REPLACE TEXT =='10' WITH YOUR CONTENT $(Read more

    step -1
    give class name for your report like– emp
    at report region , appearance section “CSS Classes” => emp

    step -2
    create a dynamic action at page load
    action == execute javascript code
    like–
    //– replace your conditional column with “DEPTNO”, AND ALSO REPLACE TEXT ==’10’ WITH YOUR CONTENT
    $(‘.emp [headers=DEPTNO]’).each(function(){
    console.log($(this).text());
    var text=$(this).text();
    if (text == ’10’){
    $(this).closest(“tr”).children().css({“background-color”:”red”});
    }
    });

    See less
  10. Asked: November 23, 2020

    Failure to expand APEX tree after refresh

    I have rewritten my page and still get the same result. This is the same behaviour on Edge, Firefox, and Chrome. On IE, I don't know since I can't even log in to the APEX site on that browser. My antivirus software is Norton 360. Would this have an effect?

    I have rewritten my page and still get the same result. This is the same behaviour on Edge, Firefox, and Chrome. On IE, I don’t know since I can’t even log in to the APEX site on that browser.

    My antivirus software is Norton 360. Would this have an effect?

    See less