Run a Query in Nav 2017

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I'm currently training on Dynamics Navision 2017, and I'm trying to run a Query to get a preview of it. Normally, I think, a window should open to have a preview of the query, but nothing is happening.

Is this feature even available in Nav 2017 ?

Thanks,

Baptiste C.

(Sorry for my bad english, it is not my mother tongue)

*This post is locked for comments

All responses (17)

Answers (0)

Suggested answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (0)

Report

RE: Run a Query in Nav 2017

Hi, you can create a new table and page to show query data.

A simple BC example: https://yzhums.com/4869/

Hope this will help.

Thanks.

ZHU
Suggested answer

zoom2gaurav 30 on at

Like (0)

Report

RE: Run a Query in Nav 2017

NAV 2017 does not support Query in classic clients. One can create a report using a query object.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Run a Query in Nav 2017

Have you manage to find solution for this? Because I'm having the same problem
Community Member Microsoft Employee on at

Like (0)

Report

RE: Run a Query in Nav 2017

I reached to get a preview of a query. I opened a debug session and clicked 'Debug Next'. After clicking 'Run', I got a preview of the selected query. Nonetheless, it isn't always working.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Run a Query in Nav 2017

I made codeunit to open and read the first line of the query and query.READ returns 'TRUE'. So the problem comes not from the query.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Run a Query in Nav 2017

Same thing, it seems to be a general problem and no specific to the query.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Run a Query in Nav 2017

Hi,

Try a query on the language table

Data Item > Language

Column > Code

Save the Query as Q50099.

Run it from DEV.

It will display the language codes

Kind regards,

L
Community Member Microsoft Employee on at

Like (0)

Report

RE: Run a Query in Nav 2017

In fact, the result of the query doesn't really matter. The problem is that when I'm trying to run a query (even a default one) manually by clicking 'Run, there is no preview.

Here is a picture of what I made :

And here is what I expect to have after clicking :
Bidey 35 on at

Like (0)

Report

RE: Run a Query in Nav 2017

i think the best idea is to look at the table of what you want to do the query on...to just have the view of what you want the output to be like...then u create the query...

also check the column u selected and also if you set filter on any one of them...

try this...it should work.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Run a Query in Nav 2017

I'm not using it on a particular object. I have just made a new query and clicked Run on the Object Designer.