About EasyMorph Tutorials & Examples Web-help

Dynamic table name in query editor

Hello,

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:
image

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.

To learn more about EasyMorph visit easymorph.com.