ForeignKey_Edit filtering rows RRS feed

  • Question

  • User-725790043 posted

    Hi, i have a lookup table that has a column 'deleted' i don't want rows that are marked as deleted to be shown on the dropdownlist when editing or adding new records, how do i do it? thanks.

    Friday, October 17, 2008 12:12 AM

All replies

  • User-330204900 posted

    Hi Ferds, <STRIKE>Firstly is this in the FK dropdown list or the Filter Drop down list?</STRIKE> [:$] Duh! I should read the subject [:$]

    1. FK Dropdown List, I would create a new version of the ForeignKey_Edit.ascx FieldTemplate and use UIHint to select it's use.

    <STRIKE>2. Filter Dropdown, Using the Advanced Filter from DD Futures I woudl then add a new filter and use the custom filter attribute to force the use of my new custom filter.</STRIKE>

    Hope thsi helps [:D]

    Friday, October 17, 2008 11:02 AM
  • User-725790043 posted

     i will try creating the UIHint.

    can i ask you a different question? you see i have a custom page and whenever i use the sort by column (clicking the column twice), then i click on the next page, the row count is correct but some records from the first page are repeated. I don't know if this happened to anyone yet. What could be the problem? i'm really stuck.

    by the way i used Catalyst.Web.DynamicData on my list.aspx template to have a search control for the gridview.


    Sunday, October 19, 2008 8:48 PM
  • User-330204900 posted

    The first thing to check is does this happen without the custome page, if it does it could be a bug (unlikely). It is more like ly that you have introduced an issue, try commenting out any custom code in the code behind and see what is causing the issue.

    I know this may sound obvious but it is easy to run away trying to solve the issue without going back to basics. I know I do it myself [:D]

    Monday, October 20, 2008 2:18 AM