AXForum - DAX Blogs - alirazazaidi: In keyword While select statement X++ Dynamics 365 for finance and operations - Показать сообщение отдельно - alirazazaidi: In keyword While select statement X++ Dynamics 365 for finance and operations

Blog bot · 20.03.2019, 20:12

Источник: https://www.tech.alirazazaidi.com/in...nd-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 :
D365/AX7:SQL IN Operator In X++ Where Clause (Enum Fields Only)

Источник: https://www.tech.alirazazaidi.com/in...nd-operations/