Run Query Object in Sandbox

(3) Share

Report

Posted on by LH-07011645-0

Hello everyone

I think this is a beginner's question, appreciate your help!We just moved to BC from NAV 2018. I'm NOT a developer.

In 2018 Dev Env, I could make queries, run them and Ctrl+E to take to Excel

Now I'm learning how to write queries in AL language in Visual Studio

I'm using Erik Hougaard's tutorial to test, I'm trying to run the query but the sandbox environment doesn't open, what eventually happens is the Hello world test opens instead

My question: am i missing some permission or access? Or, some other simple step?

When Query opens in Sandbox, will I be able to use Edit in Excel?

It's only me who uses these queries, and the fields used are changing so i don't need to make them accessible for all users in BC.

Just being able to extract the data from Sandbox will be enough

Thank you in advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (2)

Report

You need to add an action on the page, to run the query, see example in this link at the end where an action is added to Item List page, you need to do similar

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-object

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (2)

Report

Hi, hope the following helps.

Dynamics 365 Business Central: How to make a query searchable (Add Query to Tell me)

https://yzhums.com/59511/

Dynamics 365 Business Central: QueryCategory property – Smartlist? (Execute Queries from Pages)

https://yzhums.com/3206/

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

how to limit the access to the sandbox for an user.

Best Regards
Gerardo

Was this reply helpful? Yes No
LH-07011645-0 71 on at

Like (0)

Report

Thank you Gerardo, Suresh and Zhu, very helpful pointers.

Thanks to your help, and especially Zhu's article, (which on reading I also could not wait to try), I think the problem has been solved

Best

Louise

Was this reply helpful? Yes No