Single SOQL query to retrieve both a Currency field and the converted currency value?

Question

In Multi-Currency orgs, when a record's Currency is set to a different Currency than the running user's chosen Currency, all Currency fields on that record will be rendered in both the record's Currency AND the running user's Currency, like this:

I want to be able to do a single SOQL query to retrieve both of these currency values.

So, say that I have a Currency field Price__c on my object. I want to be able to do something equivalent to the following:

[select Id, Price__c, convertCurrency(Price__c) from MyObject__c]

However, it appears that SOQL only lets you retrieve EITHER Price__c OR convertCurrency(Price__c), but NOT both.

Any ideas on how I could retrieve both without having to do a second SOQL query??

Answer 1

Use a field alias for the aggregate expression. For example:

[select Id, Price__c, convertCurrency(Price__c) ConvertedPrice from MyObject__c]

Answer 2

As far as I can tell, the only way to get at this data is to have at least 2 SOQL queries: 1 to get the data, and 1 to query either the CurrencyType table (for simple multi-currency orgs) or DatedConversionRate table (for advanced currency management orgs), which both provide conversion rates. Once you get the conversion rates, you have to manually perform the conversions in order to achieve the desired effect.

Answer 3

I'm working on the same problem. The only solution I could find that avoids multiple queries, is to create a currency formula field declartively and to query that field as well.