Purpose

The purpose is to demonstrate the use of SQL IN operator in X++.

Limitation

The use of IN operator in X++ is only applicable for fields of data type ENUM.

Sample Code

[code language = “cpp”]
SalesTable salesTable;
container con = [SalesType::Sales, SalesType::ReturnItem, SalesType::Subscription];
while select * from salesTable
where salesTable.SalesType in con
{
Info(salesTable.SalesId);
}
[/code]