Dear Microsoft,
I would like to report a bug that happens on Business Central Wave 2 on Premise.
On the Page list - Filter Pane, the table relation "where" statement is ignored. on Page card it works correct.
The scenario to replicate is
add a where statement on tableration
field(50108; Category2; Code[20])
{
DataClassification = ToBeClassified;
Caption = 'Category 2';
TableRelation = Category2.Code where("Category 1 Code" = field(Category1)); //const('TEST')
}
Open the page list and filter with that field. the table relation opens but the where statement is ignored
Regards,
Vasilis Charalambous