By using this website, you agree to our Terms of Use (click here)
I keep catching myself trying to use F5 to run a query like I can do in SQL Management Studio. I think it would be nice if TimSQL could have keyboard shortcuts so I don't have to reach for the mouse.
Since F5 is already taken by the Browser for refreshing a webpage, how about Ctrl-Esc for SELECT and Ctrl-Insert for EXEC?
Ctrl-Esc is the normal keyboard shortcut for the Cancel button in Acumatica and Ctrl-Insert is the normal keyboard shortcut for the Add New Record button in Acumatica so I like that we'd be using normal Acumatica keyboard shortcuts.
Ctrl-Esc is nice for SELECT since you only need your left hand for it while Ctrl-Insert requires both hands which is nice for EXEC since "pressing" EXEC should require you to be more intentional.
Maybe we could swap the SELECT and EXEC buttons so SELECT comes first, then use PgUp for the SELECT keyboard shortcut and PgDn for the EXEC keyboard shortcut since those are simple keyboard shortcuts that are already used on other screens.
It would be important that the keyboard shortcuts are shown when you hover over one of the buttons, just like they do on the Journal Transactions (GL301000) screen as shown in the screenshot below.
We're thinking of removing the SELECT button and having the EXEC button do what the SELECT button currently does. Actually, we might want to call the EXEC button EXECUTE instead to mimic the button on SQL Management Studio:
That would mean that we only need one keyboard shortcut. Also, we're thinking of adding the EXEC / EXECUTE button to a AugSQL Saved Queries (QQ900003) screen as outlined in this idea so the PgUp and PgDn keyboard shortcuts would be taken.
https://www.augforums.com/forums/augsql/saved-sql-queries
So how about using Ctrl-Esc as the keyboard shortcut for the EXEC / EXECUTE button?
It would also be interesting if pressing Ctrl-V in an AugSQL window could do the following:
1. Populate the SQL Command field with whatever is on the clipboard
2. Press the EXECUTE button
This would be interesting in case you are using something like Notepad++ to write your SQL because Notepad++ can run a Macro which could do the following:
1. Alt-Tab to the AugSQL window
2. Send the Ctrl-V keystrokes to the AugSQL window
I'm not sure though if the AugSQL can override the default Ctrl-V behavior in a browser
@timrodman use Ctrl all you want, us Mac users will be fine 😉
Would having ctrl-v auto execute be an option one could toggle between? I don't always paste full statements so having the option would be great. I still haven't played enough with Acumatica to know if you can inject our own Javascript, if so, capturing ctrl-v shouldn't be too difficult, unless Acumatica's event listener pre-empts it.
@charles-craig Great points, thank you!
I was subconsciously discriminating against Mac users. Thank you for reminding me that not everyone uses Windows. What's the Mac keyboard command for the Add New Record button in Acumatica? On Windows it's Ctrl+Ins (screenshot below).
Also, great point about partial statements, hadn't thought about that yet. How about using the Ctrl+Ins shortcut instead (is that on Mac?). That could make sense.
@timrodman Just checked and it is still Ctrl+Ins on the mac, but that's only because I have an external keyboard that has Windows keys on it. Without it I'm unable to use the shortcut. The internet says I should be able to use fn+enter, but that does not work for me and most people also looking for that answer.
So I decided to comb through their javascript! I was able to simulate it by running this code in my browser console:
document.getElementById('main').contentWindow.document.getElementById('ctl00_phDS_ds_ToolBar_Insert').click();
'main' is the id the the iframe they use... oh how I hate their love of iframes. Especially in the documentation.
I checked bunch of pages and the add button always uses this 'ctl00_phDS_ds_ToolBar_Insert' as its element id. So one could add a custom event listener to, say, a Chrome extension for us Mac folk and then be able to use whatever custom key combo to execute it. Otherwise, if you can inject custom javascript into the main layout (again I'm too new to know what Acumatica lets us do) that would save from having to install a browser extension.