Change Column Filter Value

ASP.NET Maker General Discussion (ASP.NET Maker)
1

Hi there! I want to change a field’s displayed value without modifying it in the database table or view. I successfully changed the ViewValue in RowRendered using the following code:

if (Convert.ToString(FieldName.CurrentValue) == "A") {
   FieldName.ViewValue = "B";
}
if (Convert.ToString(FieldName.CurrentValue) == "C") {
   FieldName.ViewValue = "D";
}

My question is: How can I update the column filter to use the new displayed values instead of the original ones?

2

The data in the column filter are returned by Ajax so you may need to use the Lookup_Selecting server event to format your own data.

3

Hi, thanks for your response. I’m still stuck on Lookup_Selecting. I saw the Page_FilterLoad event in the documentation, which might be the solution, but I can’t find it in v2024. Do you happen to know where it is?

5

It is for Summary/Crosstab reports only

6

My bad, I misunderstood. I apologize!