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

  • 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?

    Wednesday, November 2, 2016 4:56 AM


All replies

  • 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
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 2, 2016 9:35 AM
  • User207847464 posted

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

    Thursday, November 3, 2016 3:13 AM
  • 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.

    Thursday, November 3, 2016 10:25 AM
  • User207847464 posted

    Hi sjnaughton,

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

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, November 13, 2016 5:29 AM