Login
Latest Development Blogs
Forum Topics Post
Browse By Tag
All of this works, the only problem is the context menu for the Filter Type is incorrect. We would expect to see a list that contains:
"Not Set, Equals To, Does Not Equal To, Like, Does Not Like, Contains, Does Not contain, Is Null, Is Not Null, Is Empty, Is Not Empty"
but instead we get a list that contains:
"Not Set, Greater Than or Equals To, Greater Than, Equals To, Does not Equal To, Less Than or Equals To, Less Than, Is Between, Is Not Between, Is Null, Is Not Null".
It looks like the problem is the set of Filter Types is the grouping that would go along with integers or dates. By supplying an alternate FilterKeyField and specifying TextBox as the FilterEditType we would expect the proper list of filter types to be displayed.
We've tried adding/removing the filter types using the instructions here (http://www.intersoftpt.com/Community/WebGrid/How-can-I-remove-grid-filter-options-like-Is-Not-Empty-or-Is-Null-etc/) and in the Support Docs but we consistently get this JavaScript error: "Unable to get value of the property 'SetChecked': object is null or undefined". This error occurs in the compiled/obfuscated Intersoft JavaScript so debugging is not possible.
I've attached a sample page that highlights the Filter Type context menu issue. We've modified the SupplierID column to filter by ProductName and use TextBox as the filter type. A few of the options actually do work but the filter type menu is missing the "Like" and "Contains" options. Compare that to the ProductName filter menu which has the correct list of filter type options.
FYI: We are using WebGrid 7.0.7200.401 and the issue has occurred in all browsers tested.
Please let me know if there are any possible fixes or work arounds as this functionality would be very useful in our app.
Hi Scott,
I can replicate your issue in our local end. Unfortunately, this problem happens because the Filter menu still same like on original value. For example, if the original column's data type is integer and valuelist change the text in the column into string data type, the filter menu's option still shown like integer filter menu.
I've submitted this issue as Work Item #1221 and make this high priority to be fixed to our developer. Sorry for this inconvenience and thank you for your valuable feedback.
Regards,
Bernard
Bernard, does the grid auto-detect/decide which datatype it's going to use for a column? I tried setting the DataType to "System.String" and even set ColumnType to "Text" but it didn't seem to help.