SqlJoinType in query object dataitem in not working

Business Central/NAV User Forum
1

Hi Experts,

SqlJoinType in query object dataitem in not working. No matter I was using SqlJoinType=FullOuterJoin; SqlJoinType=LeftOuterJoin;or SqlJoinType=RightOuterJoin; It always return the result as SqlJoinType=InnerJoin.“Item Ledger Entry” table does not contain the item with inventory quantity is 0. So I use it full outer join with item table to get all the locaiton info. and item info. But it always return the record match in the both two tables. The result is always inner join. My code is list below.

dataitem(ItemLedgerEntry; “Item Ledger Entry”)
{
column(ItemNo; “Item No.”)
{
}
column(RemainingQuantity; “Remaining Quantity”)
{
Method = sum;
}
column(LocationCode; “Location Code”)
{
}
column(Open; Open)
{
ColumnFilter = Open = const (true);
}
dataitem(Item; Item)
{
DataItemLink = “No.” = “ItemLedgerEntry”.“Item No.”;
SqlJoinType=FullOuterJoin;
column(number2; “No. 2”)
{ }

            column(itemCategoryCode; "Item Category Code")
            {             }
        }
  }

AL 2.1.69331