search

dufoli / Salesforce-Inspector-Advanced

Chrome extension to add a metadata layout on top of the standard Salesforce UI to improve the productivity and joy of Salesforce configuration, development, and integration.
https://chromewebstore.google.com/detail/salesforce-inspector-adva/dbfimaflmomgldabcphgolbeoamjogji
MIT License
11 stars 2 forks source link

ORDER BY clause in SOQL not working properly #184

Closed ShrodingersKat closed 1 month ago

ShrodingersKat commented 1 month ago

Make sure to read the troubleshooting section before creating an issue

Describe the bug When I export data using ORDER BY in the SOQL, there's some ordering happening but I can't understand how as the order is wrong

To Reproduce Steps to reproduce the behavior:

  1. Go to Data Export
  2. Enter a query that tries to order on picklist values (mine had more than one word but I'm not sure it matters)
  3. Check ordering of column

Expected behavior I expected to see the records ordered consistently by that column. That was not the case. Screenshots will be added

Screenshots If applicable, add screenshots to help explain your problem. Screenshot 2024-10-23 182517 Screenshot 2024-10-23 182455 Screenshot 2024-10-23 182430

Desktop (please complete the following information):

Additional context Add any other context about the problem here.

dufoli commented 1 month ago

Hello, Thanks for reporting this issue. It is strange behaviour but I need to check if it is related to saleforce query api or inspector... Can you try to execture the same query on developper console > query tab ?

ShrodingersKat commented 1 month ago

Yes, good call. Definitely something weird going on. This is from the Developer Console.

image

ShrodingersKat commented 1 month ago

Guess that's that. Sorry for the nuisance. Should have checked first this. I just didn't think that as a possibility. Very odd behaviour.

ShrodingersKat commented 1 month ago

Thanks.

dufoli commented 4 weeks ago

@ShrodingersKat Great ! sad that it come from core ;-(