Filter Bar with Date
I have this issue when I try to apply a date filter:
Replies 11
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?
![]()
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?
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
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
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.
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
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
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"?