Quick Tip: How do I run a Query from VSCode?

Since the release of the new development environment, some thing have changed… And one of these things is how you, as a developer, run a query. Imagine you have created this amazing query object:

Well, in the past you could have simply used Ctrl+R or the Run button in the object designer, to get a preview of the first 10.000 rows, but now you can’t run a query object anymore, from VSCode, or can you?

Ofcourse you can. Simply deploy your extension to your sandbox and then append the following in the URL:

• https://businesscentral.dynamics.com/[REPLACE-WITH-YOUR-TENTNANT-ID]/Sandbox?query=[ID]

For example:

And voila the result:

Or you can also simply use Waldo’s extension:

https://marketplace.visualstudio.com/items?itemName=waldo.crs-al-language-extension

and then:

Enjoy!