This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,791 Users
  • 2,269,776 Discussions
  • 7,916,827 Comments

Discussions

IG LINK COLUMN NOT WORKING AFTER 42 ROWS

wikki26
wikki26 Member Posts: 276 Blue Ribbon
edited Apr 23, 2020 8:11AM in APEX Discussions

Hi,

I have create one IG which is populating data from a database table.

I have create a link on 1 column, which is working fine till 42 Records, but after 42 records when grids refresh further records, Link does not work.

How can i fix this issue?

Regards,

Waqas    

Tagged:
wikki26
«1

Comments

  • Keyser
    Keyser Member Posts: 829 Bronze Trophy
    edited Apr 21, 2020 6:24AM

    42

    do you see anything in the browser dev tools console when you click a link that doesn't work?

    do you see anything in the debug window when you click a link that doesn't work?

    if you order the rows differently is it still row 43 that fails?

  • wikki26
    wikki26 Member Posts: 276 Blue Ribbon
    edited Apr 21, 2020 8:23AM

    When i click on the link nothing generates in the log, dev tools console and the debug window.

    the link is working only on 1st 42 rows, in all the ways.

    Regards,

  • Keyser
    Keyser Member Posts: 829 Bronze Trophy
    edited Apr 21, 2020 8:39AM

    can you tell us more about the link?

    what type of link is it? Target = "page in this application", "page in another application" or "URL"?

    do you set any item values as part of the link definition

    can you reproduce the problem with an application on apex.oracle.com and share the url and credentials with us?

  • wikki26
    wikki26 Member Posts: 276 Blue Ribbon
    edited Apr 21, 2020 9:02AM

    UR base:

    Behavior:

    Click on the Cell, Cell is selected, and do some calculation in javascript Dynamic Action which is being active using jQuery Selector.

    Regards

  • Keyser
    Keyser Member Posts: 829 Bronze Trophy
    edited Apr 21, 2020 9:18AM

    the javascript code could be doing things that might cause your issue or the jQuery selector may be wrong but we have no way of knowing without seeing it, if you can reproduce the problem on an apex.oracle.com application and share it with us it would help a lot

  • wikki26
    wikki26 Member Posts: 276 Blue Ribbon
    edited Apr 22, 2020 4:55PM

    Hi,

    Please check my example, simple link and open and dialog window.

    https://apex.oracle.com/pls/apex/wikkitestcases/r/test-application25/test-42-row-ig-link-fails?session=542665501661

    user name: demo

    password: testmycase123

  • Keyser
    Keyser Member Posts: 829 Bronze Trophy
    edited Apr 22, 2020 6:26PM

    can you change the Event Scope on the Dynamic Action to "Dynamic" and try it again please?

    pastedImage_0.png

    wikki26
  • wikki26
    wikki26 Member Posts: 276 Blue Ribbon
    edited Apr 23, 2020 6:07AM

    Now this issue has fixed. thanks alot,

    but another issue raised,

    When user clicks on a cell, then we colored that cell using javascript function with toggling.

    color a cell on click, and if again click and cell is colored then de-color the cell

    this was running fine , but after setting the dynamic option this is not working any more. Please guide.

    below functions have been created under Page level Function and Global Variable Declaration:

    function highlight_ig_cells() {

        $(".my-report td.my-column1").on( "click", function(){

                $(this).addClass('color-cell-block color-background u-warning-bg');

                $(this).css({"text-decoration":"none"});

        });

        $(".my-report td.my-column2").on( "click", function(){

                $(this).addClass('color-cell-block color-background u-warning-bg');

                $(this).css({"text-decoration":"none"});

        });

        $(".my-report td.my-column3").on( "click", function(){

                $(this).addClass('color-cell-block color-background u-warning-bg');

                $(this).css({"text-decoration":"none"});

        });

    };

    function de_highlight_ig_cells() {

        $(".my-report td.my-column1").on( "click", function(){

                $(this).removeClass('color-cell-block color-background u-warning-bg');

                $(this).css({"text-decoration":"line-through"});

        });

        $(".my-report td.my-column2").on( "click", function(){

                $(this).removeClass('color-cell-block color-background u-warning-bg');

                $(this).css({"text-decoration":"line-through"});

        });

        $(".my-report td.my-column3").on( "click", function(){

                $(this).removeClass('color-cell-block color-background u-warning-bg');

                $(this).css({"text-decoration":"line-through"});

        });

    };

  • wikki26
    wikki26 Member Posts: 276 Blue Ribbon
    edited Apr 23, 2020 6:40AM
  • Keyser
    Keyser Member Posts: 829 Bronze Trophy
    edited Apr 23, 2020 6:56AM

    i'd start a new thread if i were you mate, there are some very good CSS people on here (i'm not one of them) who may be able to help quicker than i can

    put CSS in the thread title and they'll be more likely to have a look

    explain the business rules for what should happen when the user clicks, popup, strikethru etc... in the body of the thread and include your example app