function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Rahul BorgaonkarRahul Borgaonkar 

Running soql in developer console -> query editor and in workbench

Hi,
I am trying to run a query below from developer documentation
SELECT Amount, FORMAT(amount) Amt, convertCurrency(amount) convertedAmount, FORMAT(convertCurrency(amount)) convertedCurrency FROM Opportunity where id = '0069000000va8SS'
When I am running this query from developer console -> query editor I am getting only first column (Amount) as result. And not other columns are showing.

but when I run same query from Workbench it is showing correct results.

User-added image
Could you please let me know what could be reason?

Best Regards,

Rahul
Lalit Mistry 21Lalit Mistry 21
Hi Rahul,
Fields with alias in SOQL do not display in query editor.
Executing below query should help
SELECT FORMAT(amount) , FORMAT(convertCurrency(amount)) convertedCurrency FROM Opportunity where id = '0069000000va8SS'

Mark this as an answer if answers your question.
Rahul BorgaonkarRahul Borgaonkar
Hi Lalit,
Thanks for your reply. Much appreciated.
Could you please share SF documentation for these details? I just need it for my future ref.
Best Regards,
Rahul