Dropdown Filters do not show when using a View...?

Question

User207847464 posted

Can someone please advise me on how to make dropdown filters appear when using a View?  They show up when using a base table, but not when I use a View.  For example, these are my tables:

1) AppType: AppTypeID [PK], AppTypeDesc

2) MainApp: AppID [PK], AppName, AppTypeID [FK] - if display this table, then dropdown by AppTypeDesc shows up -  so far so good.

Now create View:

ViewAppPlusAppType: AppID, AppName, AppTypeDesc - no dropdowns appear - how to fix this?

Answer 1

User-330204900 posted

Hi Tustin, you have two options:

1. Create custom Filters
2. Add relationships in the EDMX/POCO classes see http://stackoverflow.com/questions/2184617/how-to-create-a-relationship-between-table-and-view-in-the-entity-framework

Answer 2

User207847464 posted

Hi sjnaughton, thank you!  I will try it and let you know how it works out for me!  Stay tuned! 

Answer 3

User-330204900 posted

If you have trouble configuring the Relationships with the view e-mail me on steve AT NotAClue.net and I can help I also have some custom filters I use just for views.

Answer 4

User207847464 posted

Hi sjnaughton,

I added an Association & Referential Constraint between the View and (Lookup) Table and the dropdown shows up now! :)  Thanks much.

BTW, how can this be done with a Custom Filter?  Do you have any sample code you could post here?  Thanks again.