Grid not refreshing when IDO is refreshed

This one is annoying as I went through this once before & can't for the life of me remember what the solution is.

I've got a Grid on a form that is tied to a Primary Collection. A Filter is applied based on the selection made in a Drop List. When a Button is pressed, the Filter is set and the Primary Collection is refreshed. If I look at the number of elements in the Primary Collection, it is returning the correct number of records. However the Grid is not displaying them. It is showing that it has been modified (Red * next to the first column).

How do I get the Grid to display the results of the newly filtered Primary Collection?

Current FormScript for the event:

public void CheckActiveRestocks(string pRestockLoc, string pWarehouse, string pRank)
      {
         if (String.IsNullOrEmpty(pRestockLoc))
         {
            Application.ShowMessage("Please select a restock location.");
            return;
         }
         Application.ShowMessage(ThisForm.PrimaryIDOCollection.GetNumEntries().ToString());
         ThisForm.PrimaryIDOCollection.Filter = String.Format("(Loc LIKE '{0}%') AND (ilocUf_qvi_RestockTransitLoc <> NULL) AND (Whse='{1}') AND (Rank={2})",pRestockLoc,pWarehouse,pRank);
         Application.ShowMessage(ThisForm.PrimaryIDOCollection.Filter);
         ThisForm.PrimaryIDOCollection.Refresh();
         Application.ShowMessage(ThisForm.PrimaryIDOCollection.GetNumEntries().ToString());
         ThisForm.GenerateEvent("StdFormRefresh");
      }

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

Dim oPrimaryIDOCOllection As IWSIDOCollection

oPrimaryIDOCOllection.Filter = "??????"

oPrimaryIDOCOllection.Refresh()

0911060553270289.pdf

BradleyBrown

Might I suggest using one or move variables to set the permanent filter expression on the primary collection. Then when the selection is made in the drop list you can have the primary event on that component set the filter variable(s) accordingly. When modified, the framework will take notice and refresh the collection automatically. Much easier than the form script route you're taking.

You can use one variable to set the entire filter or use many to set different parts of the where clause.

Stephen Cena

1371407: I tried that permutation & it still isn't working. When that code fires, the Collection does get the right number of records but the Grid it's attached to doesn't update.

Stephen Cena

I've only ever set the permanent Filter manually. Does it just use standard Mongoose code? Ex: (Rank >= V(vRankEntered), or how do you do it programatically?

BradleyBrown

Yes, like that.

Legacy Contributor

You do want to quote the value to make sure it applies correctly. Rank >= FV(vRankEntered).

As for your refresh issue. You might want to check your binding on the collection and the options under the collections tab for refresh. Based on what you have here it should work.

BradleyBrown

Thanks Paul... been a long morning and forgot the FV.

Stephen Cena

Paul: That was precisely what it was. For whatever reason I had "object" not "objects" for the Primary Collection. Once I corrected my mistake it worked as expected.

And good to learn about using variables in the Permanent Filter too.

Copyright © 2025 Infor. All rights reserved.