Apex Code Development You need to sign in to do that
Don't have an account?
Running soql in developer console -> query editor and in workbench
Hi,
I am trying to run a query below from developer documentation
but when I run same query from Workbench it is showing correct results.
Could you please let me know what could be reason?
Best Regards,
Rahul
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.
Could you please let me know what could be reason?
Best Regards,
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.
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