Hi,
I have a lot of forms and I use the filter control to allow people to filter the data source for the form they are on. It use to work with no issues all the time and recently like a couple of months ago it stopped and am now trying to figure out why. Really all I do is when the person selects the drop down I apply the fill all method for the dataset and then use Applyfilter when they press a button. Like I said it use to work fine but dont know what I did to break it, please help
I am getting complaints and really need to fix this soon
Below is the message I get when trying to use the filter.
An unhandled exception of type 'System.Data.EvaluateException' occurred in System.Data.dll
Additional information: The expression contains undefined function call Contains().
Steps to Reproduce:
Run the application
Try to filer data using the Contains filter condition by the Department field
Actual Results:
Nothing happens
Expected Results:
The data should be filtered based upon the applied condition
Bug Report
Q382642
Visible to All Users
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Hi Kevin,
Thank you for contacting us.
I should say that the information you provided is not enough for us to determine the cause of this issue. Would you please provide us with a sample project that demonstrates the glitch, so that we can investigate it and find a solution? Please also provide us with a full call stack of the exception. It will help us further research this issue.
I'm looking forward to your feedback.
Thank you,
Pavel.
Hi, ok I created a simple from with just a few fields from a dataset. I then used the popup container and filter controls to filter the data and it does not work. This is all I use to do to get it to work but does not anymore and dont know if I am doing something wrong or did something change. Anyway I know you dont have the data but I believe there is enough info that you can see what I am doing, thanks for your help. Kevin
Hi Kevin,
Thank you for your sample. It helped me a lot to understand the cause of the problem. I have managed to reproduce this issue on my side. It appears to be a bug in our FilterControl. I will convert this issue to a bug report and we will do our best to fix this problem soon.
Thanks,
Stan
Hi Stan,
Can you tell me if there has been any progress on resolving this issue. I would appreciate any help in this and would like to correct my database as soon as possible. thanks for your help
Kevin
Hi Kevin,
First, I apologize for the delayed response. Our developers have not yet found a solution to this problem. I'm going to discuss this issue with our developers right now and we will do our best to find a solution ASAP.
Thanks,
Stan
Hi Kevin,
I have discussed this problem with our developers, and we have come to the conclusion that this bug appeared while we were implementing the capability to filter by child objects (FilterControl - Add a capability to add filter criteria for involving child objects). I'm afraid that fixing this bug will take us additional time, because this functionality is broken at the base classes level. Anyway, I will do my best to speed up this bug fix. I will inform you about any progress we have regarding this issue. Once again, I apologize for any inconvenience this incident might have caused you.
Thanks,
Stan
Hi Kevin,
I am glad to inform you that our developers have found a way to overcome this problem. We are currently applying this solution to source code. I hope that this fix will be introduced in a couple of days after all automatic tests are passed.
Thanks,
Stan