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 ???


  • Replied 10 September 2017, 11:29 am EST


    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.


  • Replied 10 September 2017, 11:29 am EST


    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.


Need extra support?

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

Learn More

Forum Channels