Insert new line on second List Part - The view is filtered, and the entry is outside the filter

samantha73
samantha73 Member Posts: 125
Hi Guys
I have created a second list part on the Service order screen to show service item worksheet table rows, second list is filtered by the service item lines . same hierarchy such as sales lines and item tracking lines. all works when viewing records however I cannot insert a new record to the second list part (items and resources). get the error:
""The view is filtered, and the entry is outside the filter. Some actions may not work""

Code:
part(ItemsAndResources; "Service Item Worksheet Subform")
{

ApplicationArea = Service;
Provider = ServItemLines;
Editable = true;
SubPageLink = "Service Item No." = field("Service Item No."), "Document No." = field("Document No."), "Document Type" = field("Document Type");
}

Best Answer

  • kriki
    kriki Member, Moderator Posts: 9,133
    Answer ✓

    On the subpage, you might need to add some code in the OnNewRecord-trigger.

    The code must set the fields connecting it to the parent:

    You might need to change the filtergroup to 4 (I think) see Record.FilterGroup([Integer]) Method - Business Central | Microsoft Learn

    Like:

    Rec.FilterGroup(4);

    "Some Field" := GetFilter("Some Field");

    Rec.FilterGroup(0);

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Answers

  • zhamany
    zhamany Member Posts: 1

    Presently facing the same issue. Have you fixed the problem?

  • kriki
    kriki Member, Moderator Posts: 9,133
    Answer ✓

    On the subpage, you might need to add some code in the OnNewRecord-trigger.

    The code must set the fields connecting it to the parent:

    You might need to change the filtergroup to 4 (I think) see Record.FilterGroup([Integer]) Method - Business Central | Microsoft Learn

    Like:

    Rec.FilterGroup(4);

    "Some Field" := GetFilter("Some Field");

    Rec.FilterGroup(0);

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!