Useful predefined functoins

Current date and time 

PurchTable.AccountingDate   = DateTimeUtil::date(DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::getSystemDateTime(), DateTimeUtil::getUserPreferredTimeZone())); 

with in qutoation string extraction

example :   'Test'

   int len = strLen(_formula);

   int exprVal1 = strScan(_formula,"'",1,len);

   int exprVal2 = strScan(_formula,"'",exprVal1+1,len);

   int exprVal1Act = exprVal1+1;

   if(exprVal1 && exprVal2)

   {

       Description typeId = subStr(_formula,exprVal1Act,exprVal2-(exprVal1Act));

  }

Num2Str convert number to string

num2Str(_value,1,2,DecimalSeparator::Dot,ThousandSeparator::None);


Formula conversion from string mathematics formula to result

 ProdMathEvaluator mathEvaluator = ProdMathEvaluator::construct();

 mathEvaluator.parmHandleException(true);

 mathEvaluator.parmThrowOnError(false);

 mathEvaluator.parmCalculationExpression(formula);

 formulaValue =  mathEvaluator.evaluateExpression();

 return formulaValue;


Loop through form datasource records fds and insertrecorded list , form refresh shiftF5  #Taskrestore 

 #Task        

 SIGSamplingTypeLine  sampleLine;

  NXRSamplingQualityReportSectionElements sectionElements;


  RecordInsertList insList = new RecordInsertList(tableNum(NXRSamplingQualityReportSectionElements),true,true,true,true,true);


  for (sampleLine = SIGSamplingTypeLine_ds.getFirst(true) ? SIGSamplingTypeLine_ds.getFirst(true) : SIGSamplingTypeLine_ds.cursor();

  sampleLine;

  sampleLine = SIGSamplingTypeLine_ds.getNext())

  {

      sectionElements.clear();

      sectionElements.ReportSecId = qualitySec.ReportSecId;

      sectionElements.TypeId = sampleLine.SampleId;

      insList.add(sectionElements);

  }

  insList.insertDatabase();


  element.task(#taskRefresh);


Comments

Post a Comment

Popular posts from this blog

Ledger dimensions and financial Dimensions X++

   //  Get individual dimensions from ledger dimensions         if (accEntry.LedgerDimension)         {             LedgerDimensionPreviewTmp   ledgerDimensionPreviewTmpLocal;             // Build the preview data.             ledgerDimensionPreviewTmpLocal = LedgerDimensionPreviewTmp::buildLedgerDimensionPreviewTmp(accEntry.ledgerDimension);             select firstonly ledgerDimensionPreviewTmpLocal                 where ledgerDimensionPreviewTmpLocal.Name == "Funds";             fundValue = ledgerDimensionPreviewTmpLocal.Value;             select firstonly ledgerDimensionPreviewTmpLocal                 where ledgerDimensionPreviewTmpLocal.Name == "MainAccount"...
Read more

Logistics address, postal address, address phone fax contact information

// Find primary address by roles  LogisticsPostalAddress postalAddr;  postalAddr = DirParty::findPostalAddressByRole(DirPartyTable::find(companyInfo::find().PartyNumber).RecId,LogisticsLocationRoleType::Invoice); Get Description/ name of location LogisticsLocation::find(postalAddrInvoice.Location).Description // Find contact information (Generic one) DirPartyContactInfoView contactInfoView; contactInfoView = DirPartyContactInfoView::find(partyRecId, _location); // Find primary address by roles regardless primary or not public  LogisticsPostalAddress getPostalAddressByType(DirPartyRecId _party, LogisticsLocationRoleType _type)     {         DirPartyLocation        partyLocation;         DirPartyLocationRole    partyLocationRole;         LogisticsLocation       location;         LogisticsLocationRole   locationRole;   ...
Read more

Consume odata/web api d365fo and parsing json content

// Two types of content type url will have usually , //1. normal URL encocoding(means adding parameters in url link)   //2. multiform-data(values needs to specify on webforms to accesss data ) //Check RetailCommonWebAPI and do find references how they are consuming odata API    class ALMMenaiHRMSIntegrationService {     str accessToken,responseJsONData;     RecordInsertList recIns;     public void  getAuthToken()     {         RetailCommonWebAPI  webApi;         str                 rawResponse;         RetailWebResponse   response;         URL loginURL;         str contentType;         Map docFields = new Map(Types::String, Types::Class);         webApi = RetailCommonWebAPI::construct();         loginU...
Read more