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!


Discover more from think about IT

Subscribe to get the latest posts sent to your email.

One Thought on “Quick Tip: How do I run a Query from VSCode?

  1. Ask for query to be added to the startupObjectType keyword in VSCode (launch.json).
    https://github.com/microsoft/AL/issues/5458

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Post Navigation