Filter not working.

Posted by: jmrodriguez on 10 September 2017, 11:29 am EST

  • Posted 10 September 2017, 11:29 am EST

     Hi, i have a filter that contains a float data column from data base, when i increase de filter value and click in any filter type, the grid cannot bind data, and shows me a sintax error.

     Does anyone knows, how to filter float values ???

     Thanks..

  • Replied 10 September 2017, 11:29 am EST

     Hi,

    Which grid control are you using and what is the version number?  Also, how are you creating the grid?  If you can provide more information or a small sample, then perhaps I can help.  Thanks.

    -Raleigh

  • Replied 10 September 2017, 11:29 am EST

     Hi,

    I can see the issue, we are investigating it. Eventually it occurs because the
    dataset to filter data requires a '.' symbol as a decimal separator.

    At the moment I'd suggest a simple workaroung, create the following event handler

        void C1GridView1_Filtering(object sender, C1GridViewFilterEventArgs e)
        {
            e.Values["Freight"] = ((string)e.Values["Freight"]).Replace(',','.');
        }

    In the code above Freight is a data field of the double data type.

    Regards,
    Sergey.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels