Run a Query in Nav 2017

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (17)

Answers (0)

M.Zayed 462 on at

Like (0)

Report

Hi,

If the join between the Query Dataitem contain an error you wonot be able to have any results (Meaning your page will be empty)!

Take a look again the join relation between each dataitem, I am sure that there are something wrong with it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks !

I tried a simple Query : I put a DataItem with 'Item' as DataSource, and one Column with 'No.' as DataSource.

Normally, I don't need to set other property.

Was this reply helpful? Yes No
M.Zayed 462 on at

Like (0)

Report

are you sure that in DB/Table there are Records?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The table 'Item' has some rows. I'm using the Database Cronus to do the exercices.

I tried on Nav 2016 and all is working fine.

Was this reply helpful? Yes No
M.Zayed 462 on at

Like (0)

Report

When I go to the Official Microsoft link about Query i canot see NAV_2017 under the point "Other versions". This is wired

I really would like to help you, but I donot have NAV_2017. Currently we are using NAV_2016

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

That's why I'm posting this question, there's no documentation about Nav2017.

Thanks for your help !

Was this reply helpful? Yes No
Bidey 35 on at

Like (0)

Report

on what particular objects are you trying to run the query....??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Bidey 35 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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 :

Was this reply helpful? Yes No