How to write a OR condition in two different fields in Query Range

Finance and Operations/AX Developer Forum
1

How to write a OR condition in two different fields Query Range

2

Hello Sathees

like this
select sum(Qty) from InventTrans where InventTrans.ItemId == InventItemGroupItem.ItemId &&
(InventTrans.StatusReceipt == StatusReceipt::Purchased || InventTrans.StatusIssue == StatusIssue::Deducted
||InventTrans.StatusIssue == StatusIssue::OnOrder || InventTrans.StatusIssue == StatusIssue::Sold)

3

Hi PushpendraSingh ,
Thank You For Your Reply but I want

How to write OR Condition use in Query range…,

like Query addrange is work on AND condition

how to write OR ?..,

4

See this documentation,
msdn.microsoft.com/…/aa893981.aspx