search

superfell / SoqlX

SoqlXplorer is an awesome tool for developers using the Salesforce.com platform.
https://pocketsoap.com/osx/soqlx/
Other
273 stars 53 forks source link

repeating returns columns. #92

Closed rodandersen closed 3 years ago

rodandersen commented 3 years ago

Describe the bug Here is my query: select id, Solar_Projectr.servicer.id, servicec from case where servicec = null and solar_projectr.servicec <> null and createddate = this_year

(I know there is no reason to __r.id just easy to reproduce the problem). If I remove that from the query it is normal. To Reproduce

Expected behavior I would expect three columns of data returned. I get a lot more than that. Export to excell shows more that double letter columns for the return data

Screenshots If applicable, add screenshots to help explain your problem.

image

Desktop (please complete the following information):

Additional context

superfell commented 3 years ago

That's odd. In my testing it looks like the column is repeated for the number of rows with non-null values. This seems to be a regression in 3.3, i couldn't reproduce it in 3.2. Will need to investigate more.