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

All responses (4)

Answers (1)

Suggested answer

Suresh Kulla on at

Like (2)

Report

Run Query Object in Sandbox

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
Verified answer

YUN ZHU on at

Like (2)

Report

Run Query Object in Sandbox

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
Gerardo Rentería Ga... on at

Like (1)

Report

Run Query Object in Sandbox

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
LH-07011645-0 on at

Like (0)

Report

Run Query Object in Sandbox

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