SQL In Operator in D365FO

SQL In Operator in D365FO

Microsoft Introduce In Operator in X++ Syntax, but it will work with Enums only.

Following are the example how you can use this

SalesTable  salesTable;

container   con = [SalesType::Sales, SalesType::ReturnItem, SalesType::Subscription];

while select SalesId from salesTable

where salesTable.SalesType in con

{

Info(salesTable.SalesId);

}

Support Faryal's Cusine