In keyword While select statement X++ Dynamics 365 for finance and operations

Hi Today I found very interesting post here , where we can use “In” keyword for While select or Select statement.

in will be enum based.

SalesTable salesTable;

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

while select * from salesTable

where salesTable.SalesType in con

{

Info(salesTable.SalesId);

}

reference :

https://allaboutmsdynamics.wordpress.com/2019/02/18/d365-ax7sql-in-operator-in-x-where-clause-enum-fields-only/