search

superfell / SoqlX

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

SOQL executed automatically on start #149

Closed bluejackDE closed 2 years ago

bluejackDE commented 2 years ago

Describe the bug When I start SoqlXplorer and login to an org, it automatically executes the most recent query. Since I have accidentally tried to execute a too long query, this would always block me from working and after minutes, result in a timeout. How can I prevent SoqlXplorer from starting the query, or, alternatively: where are the recent queries stored so that I can delete them?

To Reproduce Steps to reproduce the behavior:

  1. Have a query that is formally too long.
  2. Force-quit SoqlXplorer, because you are impatient.
  3. Start it again, login to the org
  4. Wait hours until you will be able to delete the current query.

Expected behavior Have an option to not execute the most recent query automatically after login. Alternatively: Identify the location the recent queries are stored to manually delete them from the system.

Desktop (please complete the following information):

edit: typo

superfell commented 2 years ago

It doesn’t intentionally run a query at startup. Are you selecting a stored token for login, or going through the new login flow?

On May 6, 2022, at 10:01 AM, bluejackDE @.***> wrote:

 Describe the bug When I start SoqlXplorer and login to an org, it automatically executes the most recent query. Since I have accidentally tried to execute a too long query, this would always block me from working and after minutes, result in a timeout. How can I prevent SoqlXplorer from starting the query, or, alternatively: where are the recent queries stored so that I can delete them?

To Reproduce Steps to reproduce the behavior:

Have a query that is formally too long. Force-quit SoqlXplorer, because you are inpatient. Start it again, login to the org Wait hours until you will be able to delete the current query. Expected behavior Have an option to not execute the most recent query automatically after login. Alternatively: Identify the location the recent queries are stored to manually delete them from the system.

Desktop (please complete the following information):

OS: macOS Monterrey 12.3.1 (21E258) SoqlXplorer Version 4.3 (4.3) Additional context Add any other context about the problem here.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you are subscribed to this thread.

bluejackDE commented 2 years ago

Stored token - and yes, I have reviewed the process on an org with a "safe" recent query. It doesn't execute it, but it seems to somehow try to interpret it already. My disastrous query holds 600k record ids in a WHERE clause - dumb mistake.

bluejackDE commented 2 years ago

I have now tried to circumvent this by logging in through a fresh login after removing the existing token - same behaviour. SoqlXplorer doesn't even retrieve the list of objects but immediately goes into no response mode (rotating beach ball).

superfell commented 2 years ago

You should be able to find the plist file with all the settings and queries somewhere under Library/Application Support you can delete this file while soqlx isn’t running and it should reset everything. Not near a Mac right now so can’t tell you the exact file name. If it’s beachballing then it’s not running the query as that’s all on a background thread. Thinking about it, it’s probably the soql syntax parser/colorer that it’s tied up in.

On May 6, 2022, at 10:29 AM, bluejackDE @.***> wrote:

 I have now tried to circumvent this by logging in through a fresh login after removing the existing token - same behaviour. SoqlXplorer doesn't even retrieve the list of objects but immediately goes into no response mode (rotating beach ball).

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.

bluejackDE commented 2 years ago

@superfell, thank you - file name and location would be great, because I could not locate any soqlx related files on my system, especially not in Library/Application Support and no plist file.

superfell commented 2 years ago

The file to delete is ~/Library/Preferences/com.pocketsoap.osx.SoqlXplorer.plist Alternatively you can run this from the terminal defaults delete com.pocketsoap.osx.SoqlXplorer soql In either case you should do it with SoqlX closed. And afterwards launch SoqlX again.

bluejackDE commented 2 years ago

This did the job! Thanks for your support, @superfell. Just needed to leave out the soql attribute from the command.

superfell commented 2 years ago

with the parser perf improvements in the last release this shouldn't be an issue anymore