I am trying to sum the costs of certain items in the Prod Order Component table using a DataItemTableFilter and then do a left join to the Prod. Order Line table so I still get all records even when the filter parts are not found, should just return a null in the CostAmount column.
However, the LeftOuterJoin does not seem to work as I am not getting any records from the Prod. Order Line table when there is not match found in the filtered Component table.
Any idea what I am doing wrong or should I be doing this differently.
dataitem(ProdOrderComponent; "Prod. Order Component")
{
DataItemLink = "Prod. Order No." = ProductionLine."Prod. Order No.", "Prod. Order Line No." = ProductionLine."Line No.";
SqlJoinType = LeftOuterJoin;
DataItemTableFilter = "Item No." = filter('PT001821' | 'PT001894' | 'PT001934');
column(CostAmount; "Cost Amount")
{
Method = Sum;
}
}
