I want to create a Query in AX 2012, I have tried a query on SQL, I want to implement SQL code to Query AX 2012.
I have a problem, when I have made the query, the data should appear 4 lines, but when in View in AX 2012 the data show 12 lines.
How I can create query like code SQL below ? Please advice
*Properties in Query AX 2012 (what i have to change ?)
Yes, you can create such a query. Unfortunately I can't comment on your problem, because I don't have your data (therefore the information about number of lines is useless for me) and you didn't show us the query you've generated. It's also not clear why you think you should change the properties highlighted in last two images.
Here are two suggestions for your debugging:
the SQL query can be converted to AX query like this, please try with this.
select PurchId, ItemId from purchLine
where purchLine.PurchId == purchTable.PurchId && purchLine.PurchId == 'PO1700006006'
where purchLine.InventTransId == vendPackingslipTrans.InventTransId
where vendPackingslipTrans.PackingSlipId == vendPackingSlipJour.PackingSlipId
where vendPackingslipTrans.SourceDocumentLine == vendInvoicePackingSlipQuantityMatch.PackingSlipInvoiceSourceDocumentLine
where agitPobranchView.PurchId == purchLine.PurchId
where agitPobussinesunitView.PurchId == purchLine.PurchId
where agitPochanelView.PurchId == purchLine.PurchId;
Thanks, but I mean how to create Query on AX 2012 like SQL code I have.
This's Query from me, please, correct me if i wrong
I know, I just wanna "How to use Left Join to Query in AX ?" What should I use ? and what is the difference between options on below ? Can you advise
FetchMode : 1:1
Join Mode : Inner Join
Join Mode : Outer Join
If you want an outer join, use JoinMode = OuterJoin and not JoinMode = InnerJoin.