NAV2013: Create an action running a query

 

Hi all,

have you ever tried to run a query in a scope of an end-user by using an action? It isn’t possible by default.

You are not allowed to enter a query object in the RunObject property and there is no myquery.RUN function. What you can do is export a query to file, but I want to open the query result as an user inside NAV 2013.

By having some knowledge about NAV 2009 and starting objects I tried the following C/AL statement

HYPERLINK(‚DynamicsNAV:////runquery?query=[number]‘);

AND? Yes this is working!

image

Kommentar hinterlassen

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert