Force a filter numeric filter on string column

[Romero]

I have a grid where the filters are done in the server, directly in database. One of my columns is a string representation of a number, like this:

public string NumberDisplay
{
    get
    {
        if(Number == null)
            return "--";
        else
            return Number.Value.ToString("0.##");
    }
}

As this is a string, the grid will show the string filters (contains, starts with, etc). How can I force a numeric filter (greater than, less than, etc.) on a string column? This is how the filtering is done in the database (as a number, not as a string):

case "NumberDisplay":
{
    bool addQueryParam = true;
    string sql = null;
    switch (filter.Operator)
    {
        case GridFilterOperator.IsGreaterThan:
            sql = " and (@KendoNumber is not null and mm.Number is not null and mm.Number > @KendoNumber)";
            break;
            ...
    }
    if (addQueryParam)
    {
        queryBuilder.Where(sql);
        queryBuilder.AddParameter("KendoNumber", filterValue);
    }
}
...

[Romero]

Changinf the filter.UI will only alter the input and not the filter types

c.Bound(b => b.NumberDisplay).Title("Number").Width(150).Filterable(filter => filter.UI(GridFilterUIRole.NumericTextBox));

[Romero]

I fixed this problem by using a ClientTemplate in the original decimal column

[Ianko]

Hi Romero,

The solution you have found is a valid one. I will close the ticket. 

Regards,
Ianko
Progress Telerik