Get running Select statement from Query during runtime in D365FO

By on

 

Syntax:  info(new query(queryStr(QueryName)).toString());


Example: info(new query(queryStr(Customer)).toString());

Popular posts from this blog

Send Purchase Orders to Vendor collaboration for Vendor Review in D365FO

By on
 Code snippet to send purchase orders for external vendor review (in  Vendor collaboration module)             try             {                 PurchTable purchTable = PurchTable::find(PurchId);                   PurchFormLetter purchFormLetter = PurchFormLetter::construct(DocumentStatus::ConfirmationRequest);                   purchFormLetter.update(purchTable, strFmt("Sent for vendor review",purchTable.PurchId));             }             catch (Exception::Deadlock)             {              }
Read more

Remove Prefix from a String in D365FO

By on
Code to remove any specified prefix from a string value. (Example: Remove '0' from '000018743') public static str stringWithoutPrefix(str _strValue,str _prefixToRemove)     {         str s1 = _strValue;         str s2 = _prefixToRemove;         int i = 0;         int whereFound;         for(i= 0; i < strlen(s1); i++)         {             whereFound = strnFind(s1, s2 , 1, strLen(s1));             if(whereFound > 1)             {                 s1 = strdel(s1,1,1);             }         }         return s1;     }
Read more

Odata Patch operation using Postman

By on
Script to update records using Postman. By default, system will consider the legal entity associated with the user added in Microsoft Entra ID applications for postman client id. Patch Operation: Example: URL:  {D365URL}/data/{Entity name}(dataAreaId='abcd', Unique field= 5637182305)//  Body: {     "Comment": "Test" }
Read more