Hello!
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 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