SOQL executed automatically on start

[bluejackDE]

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):

• OS: macOS Monterrey 12.3.1 (21E258)
• SoqlXplorer Version 4.3 (4.3)

edit: typo

[superfell]

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]

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]

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]

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]

@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]

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]

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

[superfell]

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