Tuesday, December 11, 2018

“in” operator in Dynamics 365 for finance and operation

//From Platform update PU21

So far, it will supporrt only for ENUM in where clause


SalesTable salesTable;
container salesStatus = [SalesStatus::Canceled, SalesStatus::Delivered, SalesStatus::Invoiced];
 
New Update:
while select salesId from salesTable
    where salesTable.SalesStatus in salesStatus 
{
}

No comments:

Post a Comment

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...