Using 13.2 I have a WebHierarchicalDataGrid with filtering in ExcelStyleFilter. In the grid parent there is a status field with values like ApprovedWIP, Closed, Ready For Test.
On my development machine using our corporate test SQL Server I have no problem applying the filter to one or more of the values. Data is correctly returned.
On our corporate live site the filter is being thrown away and the All choice is selected. If I manually clear a second time and click OK I get the above error.
Can anyone provide some information or assistance?
Thanks.
Hello Ed,
Thank you for posting in our community.
I created a small sample using WebHierarchicalDataGrid with enabled filtering behavior. I deployed the application and everything was working as expected on my side. All the data was filtered correctly and no exceptions were thrown. I am attaching the sample project that I used for my test.
Could you please test this sample project on your side and let me know what the result is.
If this sample is not an accurate demonstration of what you are trying to achieve could you please modify it in order to reproduce the issue and send it back to me for further investigation.
Additionally, I would recommend you downloading the latest service release available for you version of NetAdvantage, which currently is 13.2.20132.2255. It could be downloaded by following these steps:
1) Go to our web site www.infragistics.com and log with your account.
2) Click Support/Account in the top right corner of the page
3) You will see Welcome, [Your name] on the top of the menu that will appear. Click on the Welcome word.
4) This will lead you to My Keys&Downloads section. Select your product from the list
Under the Service Releases tab you will find the latest service release available for download.
Looking forward to hearing from you.
Accidentally clicked the ANSWER button for this when I was trying to REPLY.
Attached is the error image I mentioned.
Also, discovered that the enable (viewstate, ajax, ajaxviewstate) entries that allowed this excel filter to work on my development machine cause javascript (link button and asp:button in grid) to not open the window they are supposed to open even though the code is runni9ng all the way through.
So I'm thinking that I'm going to abandon the excel filter.
What I need now is a way, using Filtering, to add multiple values to the same column
e.g.
Dim filtering As Filtering = ugWorkItem.Behaviors.Filtering filtering.ColumnFilters.Clear() Dim columnFilter As ColumnFilter = New ColumnFilter() columnFilter.ColumnKey = "Status" ' Depending on the column type you would use a different type of rule ' (such as RuleTextNode, RuleNumberNode, RuleDateNode, RuleBoolNode) columnFilter.Condition = New RuleNumberNode(NumericFilterRules. .Equals, consultant) filtering.ColumnFilters.Add(columnFilter) filtering.ApplyFilter() ugWorkItem.DataBind()
Would prefer to use RuleTextNode, but can work with RuleNUmberNode just as easily
To expand on this request - I'm trying to get something like:
Status='Approved WIP' OR Status='Ready For Test' (could be multiple ORs)
into the columnFilter.
On most of my WebDatagrids I use a different method
SqlDataSource1.FilterExpression = filterStr
SqlDataSource1.DataBind()
ugWorkItem.DataBind()
On the WebHierarchicalDataGrid this works for the child, but the parent does not filter correctly. If there is a way to do this reliably I'd actually prefer that
After looking into this and doing some research, it has been determined to be a new product idea. I would recommend you to log it at http://ideas.infragistics.com, the Product Ideas site allows you to suggest new product features, new functionalities in existing products and controls, and even request new controls and products altogether. Members of the Infragistics Community then vote for the features and suggestions they want to see added to the products, resulting in the most popular features bubbling up to the top. When planning new releases, our Product Management team will look at the most popular features and use your feedback to prioritize upcoming work.
Both of the requests I have made under this post seem to me to be a fairly basic design element for such a control.
This leads me to believe that the WebHierarchicalDataGrid is not truly 'ready for prime time' except for very simple data display uses which in my experience is pretty rare.
Thank you for the feedback!
Another approach to create custom filtering rules is on the client by handling DataFiltering event. However this approach can lead to some unexpected behaviors as it is with your scenario. I suggest you to submit this on our website as new product idea.
I will be more than happy if you can share your feedback on our product ideas site.
Thank you in advance!