We have closed this ticket because another page addresses its subject:
Column popup filter is not applied if a checkbox was draggedHello!
The attached video shows that when I click on the item and move the mouse away, the filtering is activated and immediately returns to its original form. And it works the other way around too, when I want to deactivate the item, it immediately reverts back to the checked state.
This problem has existed for a long time, I've only finally managed to find out what exactly it is.
Vladimír
Hello Stefan,
Thank you for your effort. I managed to reproduce this behavior. We will examine it and update the following thread once we have news: Column popup filter is not applied if a checkbox was dragged.
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.
Hello Vladimír,
Thank you for the video.
I didn't manage to reproduce this behavior with our demos, so it looks like this behavior occurs in specific conditions. Could you please illustrate it in a sample project? Once we reproduce it on our side, we will be in a better position to research it further.
Hello Alex,
I have now checked 3 of my applications and it happens everywhere, but only with TcxGridServerModeTableView.
It needs the cursor to leave the menu space before filtering is done.
Vladimír
Hello Vladimír,
Am I correct in stating that the issue takes place with ServerMode views only? In that case, this behavior may depend on the behavior of some specific DB engine as well. Please check whether the issue occurs with the Microsoft.Jet.OLEDB.4.0 provider (see the attached project), or SQLite. If it does, please share a deployable project that uses one of these DB engines, so that we can test it as well.
If the issue doesn't occur this way, please check the Filter.FilterText property's value to get filter expressions and try applying them to your database manually.
I look forward to your response.
Hello Alex,
Attached are two screencasts demonstrating the problem. This issue occurs when Filtering.ColumnPopupMode = fpmClassic. If you hover the mouse over the checkbox, it works. However, if you quickly move the mouse outside the popup, this behavior occurs.
On the other hand, when Filtering.ColumnPopupMode = fpmExcel, it works perfectly.
Best regards, Stefan from Vinschgau
Hello Alex,
It seems that the query is executed twice in this case.
I'm using FireDac with TdxGridServerModeTableView.
Best regards, Stefan from Vinschgau
Hello Alex,
Look at the filter box. The filter box appears the first time you run it. The second time it disappears.
Best regards, Stefan from Vinschgau
Hi Alex,
I also replicated with TcxGridDBTableView.
Best regards, Stefan from Vinschgau
Hello Stefan,
Thank you for the detailed description and videos. While I still didn't manage to reproduce this issue, it looks like it occurs when there is a delay on an attempt to apply a filter. Could you please specify whether the view on the video uses AutoDataSetFilter or any filtering-related events? I will try to simulate a delay.
Hello Alex,
Attached is an example project. The two screencasts show how to replicate the problem. You just need to quickly drag the mouse out of the pop-up window.
It works perfectly in Excel's pop-up mode.
Best regards, Stefan from Vinschgau