Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Dexterity Virtual tabl...

Dexterity Virtual tables and ranges

(0) Share

Report

Posted on by Community Member

Hi,

I have tried to find a definite answer to this online or in a printed source, but have had no luck , so I am not sure if it is possible to use ranges to filter the data pulled in from a virtual table to a scrolling window. Does anyone know if it is possible and if so how? Or is it possible to create a view in SQL server and use it as a read only table in dexterity?

My scenario is that I want to build a lookup using a virtual table that just has the data required to be displayed in the look up. The data comes from three separate but related tables. I'd want to give the users two or three options to filter what gets populated from this virtual table, so I want to do that with a range where clause. passing in the different criteria in the where section.

The scrolling window would then be filled using the range set up by the range where criteria.

No matter what I have tried, the result set is always the unfiltered fill. Basically all records from the virtual table.

Thanks.

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: Dexterity Virtual tables and ranges

I found a way to do this. I created a view in Sql Server that joined the tables we needed. Then I created a table in dexterity with the same name and columns in my view. I had to make sure I included a DEX_ROW_ID field, so in the columns I selected from the tables in the view, I also included the dex_row_id from one of the tables.

Since this Dexterity table actually points to a view it has to be read only and the create is done outside of Dexterity and Dynamics. In Sql Server directly.

I was then able to apply ranges for scrolling windows that used this new table as the source of the range.