I am restoring the filter for a Kendo Grid in a Controller from a stored filter string. When there is an exponential (e.g. 1e-9) as a value, FilterDescriptoractory.Create() throws an exception "Expected RightParenthesis". Looking at the filter string it seems to have the correct number of parentheses.
On some occasions exponentials work but I can not determine under which. Under which conditions will exponentials work in filters?
var filterString = "ShipName~eq~'ShipName1'~and~(Freight~eq~0~or~Freight~gte~1e-9)~and~ShipCity~gt~0";
var filters = FilterDescriptorFactory.Create(filterString);