How to refresh Linked Content Grid Automatically?

[adrian1]

Is it possible to have a grid defined as linked content to another grid automatically refresh when you click its tab pane?

Thanks in advance

[Peter.Greulich]

Re: How to refresh Linked Content Grid Automatically?

Is it possible to have a grid defined as linked content to another grid automatically refresh when you click its tab pane?

I couldn't figure a way. I added an action button to the grids to do it manually.

[adrian1]

Re: How to refresh Linked Content Grid Automatically?

Thanks Peter

[frankbicknell]

Re: How to refresh Linked Content Grid Automatically?

Has anyone come up with a solution to do this automatically that they are willing to share? I too have a refresh button but think there is a better way.

If I make a change on the parent grid the linked grid does not get refreshed with the new data unless it has focus (the tab for the linked grid is selected).
I thought 'refreshLinkedContent' would do it but I was wrong.

[Jahnel]

Re: How to refresh Linked Content Grid Automatically?

I ran into the same problem.
I expected A5 to refresh ALL of the linked grids, but it does not. I also tried to find some way, but no sucess.
Tried the onRowFocus-event, does not work as well.

Still no solution?

[cptutrecht]

Re: How to refresh Linked Content Grid Automatically?

Search for the property "auto-refresh on expand"., I think it is fairly new. Is this what you are looking for?

[Jahnel]

Re: How to refresh Linked Content Grid Automatically?

Search for the property "auto-refresh on expand"., I think it is fairly new. Is this what you are looking for?

I don't think that solves my issue.
I have two grids in tabs both linked with the same field to the parent, but showing different content. That seems to be the reason.
I sent a bug report to A5 yesterday.

[TheSmitchell]

Re: How to refresh Linked Content Grid Automatically?

Is it possible to have a grid defined as linked content to another grid automatically refresh when you click its tab pane?

Thanks in advance

This is identical to another response I left in another thread - though, looking back on things, I probably should not have left this in the other thread because it was a version 10 thread... whoops! Maybe someone will come across it there and find it helpful.

I wanted to refresh a linked grid when I clicked on the tab, so I did did a bit of FireBug investigation to figure out how to register an event handler when the tabs for the relevant pane(s) are clicked.

In my onGridInitialize event - because you only want to register the event once! - I added the following (note: my "NAME_OF_LINKED_CONTENT_SECTION" is EmpHours; you will need to replace EmpHours with your content section's name):

// define event handler for pane tab click
var onPane1Click = function () {
    //Panes are 0 indexed:
    //  0 = pane 1
    //  1 = pane 2
    //  etc...
    //Must quote pane number
    var paneGridObj = window[{grid.object}._linkedGrids.EmpHours["0"] + "_GridObj"];
    if (typeof (paneGridObj) !== 'undefined') {
        paneGridObj.refresh();
    }
    return;
}

// register event handler with pane tab's click event
$e.add('{grid.componentName}_LCS_EMPHOURS.0.TAB','click',onPane1Click);

The component name of the linked content grids are stored in {grid.object}._linkedGrids.NAME_OF_LINKED_CONTENT_SECTION:
linkedContentSection.png

Name is case sensitive, so you want to match exactly.

The ID for each pane tab, you use "{grid.componentName}_LCS_" + The name of your Linked content section all upper case + "." + Pane number (starts at 0) + ".TAB".

Each {grid.object} is stored in the window. You can get the grid object using window[{grid.componentName} + "_GridObj"]. The {grid.componentName} for the grid in each pane is in the {grid.object}._linkedGrids.NAME_OF_LINKED_CONTENT_SECTION object.

Hope this helps someone.

Edit/Update
I have my linked grids displayed below my Detail View. I discovered they are destroyed and recreated every time I navigate a record - possibly because of some setting I have turned on/off. I moved my event registering code to onDetailViewOpen to solve this issue. I don't know if the linked content tabs are destroyed/created when you navigate each row if they're displayed with the grid. If that's the case, I suggest trying the code in the client-side onRowSelect event. More experimentation may be required if that doesn't do the trick.

---
Sarah

[TheSmitchell]

Re: How to refresh Linked Content Grid Automatically?

Ah. The solution I had above only works in detail views. I had to hack together something else to get it to work in a grid with a row expander. I added this to the onGridInitializeComplete event for the child grid - the linked grid, not the parent grid:

var po = {grid.object}.getParentObject();
if (typeof (po) !== 'undefined' && typeof (po.gridId) !== 'undefined') {
        var pId = po.gridId;
        var myId = '{grid.componentName}';
        myId = myId.split("_");
        var end = myId[myId.length-1].split("G");
        var myTabNum = parseInt(end[1] - 1);
        var myTabId = "TAB_" + pId + "_" + end[0] + "." + myTabNum + ".TAB";
	
        if ($(myTabId) !== 'undefined') {
                $e.add(myTabId,'click',function(e){{grid.object}.refresh();});
        }
}

Putting this here for reference later in case I need or someone else comes across it?
---
Sarah