I have a problem with the current matrix solution of NAV 2009 in the RTC.
What I want is to set a filter on the SourceTable of a Matrix page (PageType is ListPart) via code using SETFILTER or SETRANGE.
Because the filter is based on a variable that is passed to this page using a function.
You can place this code on the OnOpenPage trigger and when you debug the code and you will see that the code is executed without
problems or errors, if you place a Watch on the Rec of the page, you can see the filter being placed on the recordset, but when the page
is opened it seems that the filter is ignored and all records are shown that meet the filter in the SourceTableView property of the page.
Only when you set this filter on the OnAfterGetRecord trigger the filter will be applied.
BUT the first record in the table that meets the filter in the SourceTableView property of the page will also be shown!!!!!!
So if you set a filter on the OnAfterGetRecord trigger and no records meet this filter, you will see one record on the matrix
namely the first record in the table that meets the filter in the SourceTableView property of the page.
Can somebody help?
Now, let's see what we can see.