Thursday, 10 October 2019

HOW TO SELECT MULTIPLE VALUES IN ENUMS IN D365 CODE

HOW TO SELECT MULTIPLE VALUES IN ENUMS IN D365 CODE

Below code is used to select multiple enum values in a while loop via a container..

SalesTable  salesTable;
container   con = [SalesType::Sales, SalesType::ReturnItem];
while select SalesId from salesTable
where salesTable.SalesType in con
{
Info(salesTable.SalesId);
}

THanks,
Vikas Mehta.

1 comment:

  1. And if you want to exclude record in container, you should write where !(salesTable.SalesType in con)

    ReplyDelete

UX & Personalization: Next-Generation Workspace Experience

  UX & Personalization: Next-Generation Workspace Experience Section Content Title Build Your Dream Workspace: Advanced Personalization ...