Small and medium business | Business Central, N...

SQLJoinType Not Working as expected

(1) Share

Report

Posted on by One_&_Only_Naveen

Why in below code SQL Join now working when I add DataItemTableFilter Property.

Please some one explain. and what is the workaround for same.

dataitem(CGST_LE; "Detailed GST Ledger Entry")
                {
                    DataItemLink = "Document Line No." = Purch__Inv__Line."Line No.",
                                   "Document No." = Purch__Inv__Line."Document No.",
                                   "GST Group Code" = Purch__Inv__Line."GST Group Code";
                    SqlJoinType = LeftOuterJoin;
                    // DataItemTableFilter = "GST Component Code" = Const('CGST');
                    column(GST_Amount; "GST Amount") { Method = Sum; }
 