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??