Filter Bar with Date

Avatar
  • updated
  • Completed
I have this issue when I try to apply a date filter:








Avatar
Anonymous
Hi,

Can you please try to change your filter operation from "equal" to "between" and set a range of "30/04/2015 00:00" and "30/04/2015 00:01"?
Avatar
Anonymous
Hi also in this case the filter operation fail




Avatar
Anonymous

I try to use others operands for filter operation, just for test










Hope this help you for debug the problem.
See you soon

Avatar
Anonymous
Thank you! Please try the new version.

BTW, please note that you can quickly add filter for the currently selected cell value by pressing the Ctrl+Q keys.
Avatar
Anonymous
Many thanks. Now It's working!
I tried CTRL+Q Key but seem that the filter don't work properly


After press CTRL+Q something happen but labes are overlapped and data filter don't be apply.
See you soon

Avatar
Anonymous
Thank you for your bug report. Can you reproduce this problem? If yes, please describe the steps to reproduce it?
Avatar
Anonymous
Actually I'm not able to reproduce because after exit now all it's working.
The only thing that changed is that before it was the first time i run the last release... Sorry.
I take this opportunity to show you another thing. (Sorry I'm always in debug session)
It's normal that you can add duplicate conditions?



Avatar
Anonymous
I got it! It has been quite hard to reproduce because it happen only in a specific case...
I deserve an award! May I became a beta tester for your next Professional version of FlySpeed SQL Query?
http://www.comparingroup.com/public/WorksKO.wmv
Avatar
Anonymous
Thank you for your efforts. We'll be glad to provide the lifetime license to you. But your video gives more questions than answers. I am wondering why the [D] datasource does not list it's fields? Does it happen all the time or in some specific circumstances? Can you tell me, what is your database server? Can you send the query text you've designed, connection properties dialog screenshot? We can establish a remote session if it's convenient for you.
Avatar
Comparin Fabio
Hi, the [D] datasource doesn't list the field because during the loading of metadata you can open a query but it's fields are show in list only when the loading of metadata finish. The database is MSSQL SERVER (Express).
The bug happen in specific circumstances try:
1.
SQL TEXT:

Select '1' As [Type],
'100' As [Value]
Union All
Select
'1' As [Type],
'100' As [Value]
Union All
Select
'1' As [Type],
'200' As [Value]
Union All
Select
'2' As [Type],
'300' As [Value]
Union All
Select
'2' As [Type],
'100' As [Value]
Union All
Select
'3' As [Type],
'100' As [Value]

2.
EXECUTE


3.
Click on the fist value of the column VALUE

4.
Press CTRL+Q

5.
BUG


Please let me know if you're able to reproduce