topic Can't access in browser database editor to submit a query using BP in Product Forum

Can't access in browser database editor to submit a query using BP

StephanieStrydom — Tue, 25 May 2021 20:55:23 GMT

In my browser based application there is a SQL editor console. I want to spy this console and write a query to it. The html spying mode is off center, I think its because the console is in the middle of the screen, and all the elements in the middle of the screen spies of center. Once spied I can not write to this element. This is the issue. I was not able to upload an image, tool didn't work.

Re: Can't access in browser database editor to submit a query using BP

MiguelCarrillo — Wed, 26 May 2021 05:05:22 GMT

Hi Stephanie.

The offset may be caused if you have zoom in your browser or in your windows setup.
Have you experience this offset with other elements inside the web page or only ocurred with the SQL Editor component?
Perform the reviews i mention below in order to try to fix the offset.

If you cant write using write stage. You could use a navigate stage using the action Global Send Keys in order to write in that element.
In the link below you will find the Guide in order to use it.
https://portal.blueprism.com/system/files/2018-02/Guide%20to%20Send%20Keys%20and%20Send%20Key%20Events.pdf

If you have torubles or any doubts.
Feel free to contact me and I could help you.

Verify the zoom inside your browser.

Verify the zoom value in your screen windows settings.

Re: Can't access in browser database editor to submit a query using BP

PabloSarabia — Wed, 26 May 2021 05:20:17 GMT

Hello,

Did you try to bring it to the front or maximize the browser?

Other issue could be that you need to focus the html control before type. I have this problem with another application, and its solve "focusing" first.

Bye!

Re: Can't access in browser database editor to submit a query using BP

StephanieStrydom — Wed, 26 May 2021 08:31:18 GMT

Thanks for the suggestions, while it did not line up when I spied, it did when I highlighted it (no zoom issues I can see). It was offset by the sidebar in the browser app. So I manage to use the Global Send Keys to write to the editor. The trick was spying the inner window (excluding the sidebar) and writing to the inner window and not the actual editor. Required several trail and errors to get the Focus and Center Clicks sequence right. I ended up with focusing on the inner window, and then center click on the editor to activate it and then global send keys to the inner window.