Thread Details

Often when I execute a query the columns are displayed and exported out of order from the order I queried them. Seems like a bug and has been very annoying.

Hi Mark,

Does this happen with every query execution or is it random?  We tried to replicate this but so far haven’t been able to. Do you have a query you could send us that will illustrate the issue?

Difficult to send a query to replicate as we have custom objects we're querying off of that causes this to happen.

I wonder if this happens perhaps when trying to query for related object items, eg. a query that contains "RelatedObject__r.EvenFurtherRelatedObject__r.RelatedObjectField__c" and "RelatedObject__r.RelatedObjectField__c" and finally "ThisObjectField__c" as columns

example query that actually produced this issue:

SELECT Billing__r.Customer__r.Account_ID__c,Billing__r.Customer__r.Name,Product__r.ProductCode, Total__c FROM Billing_Line__c

The results show in column order: Account ID, ProductCode, Total, Account Name (account name is out of order, should be the second column)

Thanks Mark. This should help us determine where things are going wrong.   

Hi Mark,

This issue is corrected in the latest maintenance release, 2019.1.276.  There is one situation where the columns will still be presented in a different order than what was specified in the select statement.  When selecting multiple fields from a parent relationship, they will always be grouped and presented together, in the order they were specified in the query.  So if you have the query "select id, name, account.name, amount, account.annualrevenue from opportunity", the fields will be returned from Salesforce as follows: id, name, account.name, account.annualrevenue, amount.

If the columns could be made exactly i the order specified in the query regardless of circumstance it would be helpful.

Yes, agreed and we are looking at ways to do that. Right now we are limited to ordering columns the way they are returned by Salesforce.