BP Rule: [BPUpgradeCodeToday]:Method today has been deprecated

 Hi,

DateTimeUtil::getToday(DateTimeUtil::getUserPreferredTimeZone())

Regards,

Resource to worker relation in D365

 Hi,

ResourceView::find(this.Resource).Worker

Reagrds

Code to call the caller form refresh in D365

 Hi,

can use the below code snippets in Controller or any other class called from

        #Task

        FormRun formRun;

        formRun = element.args().caller(); //  args.caller();

        if(formRun)

               formRun.task(#taskF5);

   

Regards,

X++ code to get ExchRate() in D365

 hi,

  public ExchRate exchRate(

        CurrencyCode _fromCurrency,

        CurrencyCode _toCurrency = Ledger::find(Ledger::current()).AccountingCurrency,

        TransDate    _transDate = today(),

)

    {

        ExchangeRate     exchangeRate;

        ExchangeRateType ExchangeRateType;

        ExchangeRateCurrencyPair exchangeRateCurrencyPair;

        real             exchRate;

        CurrencyCode fromCurrency  = this.CurrencyCode;

        TransDate    transDate     = this.TransDate;

        select firstonly exchangeRateCurrencyPair   where

        exchangeRateCurrencyPair.ExchangeRateType == Ledger::find(Ledger::current()).DefaultExchangeRateType

        &&  exchangeRateCurrencyPair.FromCurrencyCode == _fromCurrency

        &&  exchangeRateCurrencyPair.ToCurrencyCode   == _toCurrency;

        return exchangeRate::findByDate(exchangeRateCurrencyPair.RecId,_transDate).ExchangeRate;

    }

Your connection is not private

Hi,

Try opening in private mode, particularly in Chrome.

 

Regards

Project resource with Role ID lookup in D365

 Hi,

               SysReferenceTableLookup     sysRefTableLookup;

        Query                       lookupQuery = new Query();

        QueryBuildDataSource        lookupQueryDataSource;

        QueryBuildDataSource        PSASchedRoleQueryDataSource;

        sysRefTableLookup = SysReferenceTableLookup::newParameters(tableNum(ResourceCategoryView), _formReferenceGroupControl);

        sysRefTableLookup.addLookupfield(fieldNum(ResourceCategoryView, CategoryId));

        sysRefTableLookup.addLookupfield(fieldNum(ResourceCategoryView, Name));

        lookupQueryDataSource = lookupQuery.addDataSource(tableNum(ResourceCategoryView));

        

        PSASchedRoleQueryDataSource = lookupQueryDataSource.addDataSource(tableNum(PSASchedRole));

        PSASchedRoleQueryDataSource.relations(false);

        PSASchedRoleQueryDataSource.joinMode(JoinMode::ExistsJoin);

        PSASchedRoleQueryDataSource.addLink(fieldNum(ResourceCategoryView, RecId), fieldNum(PSASchedRole, RecId));

Regards,