SQL Views with Dynamics NAV

abnainas

Dear All,

Can I Take a view and insert it to navision... can u tell me how navision work with views.

Best Regards

nunomaia

You can use SQL views in Navision by using Linked Tables.

abnainas

Please, I want more information. Do u have any documents ?

Regards

jlandeen

I haven't seen a lot of documentation from the product itself but I have done this a few times in both a development and a production environment.

It's not too hard to do all you have to do is build a SQL view in your Navision database that exactly matches the table definition and table name and then set the LinkedObject property to Yes. You can then apply filters to columns using standard Navision syntax and Navision will handle translating that to SQL statements executed against the view.

There are a few other articles and you may want to search the forums here:
http://www.mibuso.com/forum/viewtopic.p ... t=sql+view
http://www.mibuso.com/forum/viewtopic.p ... t=sql+view

DenSter

I think the application designer guide has a good section on linked tables.

jlandeen

Sorry you are correct there is a section in the ADG manual, however it is only 4 pages. However it's only a few pages and I generally don't see a lot of people use this feature or talk about this feature. So this is why I said "not a lot of documentation".

It really can be a useful feature for abstracting underlying table structures and working with external systems.