About EasyMorph Tutorials & Examples Web-help

Dynamic table name in query editor [DONE]


I don’t know how you could do it but here is an issue I have had from the start.

In Dynamics Nav table name in SQL server are often [company name$table name].
Usually there are several companies that are created in Nav environments.

In EasyMorph “Query Editor”, I select table and make one “visual query”.
But after that, I must swith in “Custom SQL” to change table name to make them dynamic with parameter like:

FROM [dbo].[{Company}$Sales Header]

After that I can no longer use the visual query builder.

This would be fine if there was a way to have a dynamic table name based on a parameter in visual query editor.

The ability to specify in a query the table name using a parameter has been added in version 5.1 released a few days ago.

1 Like
To learn more about EasyMorph visit easymorph.com.