Function to get Exchange Rates

Jira Code : BGGN-529

 /**
         * Function to get the currency exchange rate based on base and source currency
         * @param sourceCurrency
         * @param baseCurrency
         **/

        function getExchangeRate(sourceCurrency, baseCurrency)
        {
            try
            {
                let exchangeRate ;
                var currencyrateSearchObj = search.create({
                    type: "currencyrate",
                    filters:
                        [
                            ["basecurrency","anyof",sourceCurrency],
                            "AND",
                            ["transactioncurrency","anyof",baseCurrency]
                        ],
                    columns:
                        [
                            search.createColumn({
                                name: "exchangerate",
                                summary: "MAX",
                                label: "Exchange Rate",
                            }).setWhenOrderedBy({ name : 'effectivedate', join :'currencyrate'})
                        ]
                });
                var searchResultCount = currencyrateSearchObj.runPaged().count;
                currencyrateSearchObj.run().each(function (result)
                {
                    exchangeRate = result.getValue({
                        name: "exchangerate",
                        summary: "MAX",
                        label: "Exchange Rate"
                    });
                });
                return exchangeRate ;
            }
            catch (e)
            {
                log.debug("Error @ getExchangeRate", e);
            }
        }