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


at 1 comment:
Labels: , , , ,
Subscribe to: Posts (Atom)

Purchase Order Confirmation

  Introduction In Microsoft Dynamics 365 Finance & Operations (D365 F&O), Purchase Orders can be confirmed programmatically using th...

  • Custom Data Entity D365FO
    Custom Data Entity in few steps Step -1 Create New Project and Create a Table like below  Step-2  Now add 4 fields. Name, Age, ...
  • List of D365FO entities
      List of D365FO entities 1099 fields Accepted currencies Account structure activation Account structure allowed values Account structure re...
  • Dynamics 365 Finance & Operation WebAPI with POST MAN
    Dynamics 365 Finance & Operation WebAPI with POSTMAN Most of the time we used 3rd Party tools like fiddler, Post Man and SoupUI as cl...