ForeignKey_Edit filtering rows

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.

Answer 1

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]

Answer 2

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.

Thanks.

Answer 3

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]