SqlDbx
You are not logged in.
Hello!
SqlDbx allows results filtering based on the value in the selected cell (equal to, greater than, etc.).
The ability to filter also on multiple values (free edit also, not only selected values) would be a great improvement.
Thank you.
Offline
I am not sure about that. Why just not to filter results in your SQL statement?
Offline
Very often in my work I happen to extract many rows and only after I need to investigate results searching specific values in one or more columns (e.g. for testing purposes).
For this I find quite useful (and fast) that feature (offered by Toad).
Offline
Hello!
I still like the "improved" column filtering I suggested but now I found a bug in SqlDbx column filtering logic.
SqlDbx allows multiple results 'AND' filtering on the same column. This seems to me incorrect.
Test case:
I select: Filter > fieldName = ABC
next I select: Filter > same fieldname != ABC (the only available value now)
In this case no row is displayed (obviously) but 'AND' filtering should not be allowed in this way.
I should be able to filter the same column for different values in logical 'OR' only, while I should be able to filter different columns either in 'OR' or 'AND'.
Thank you.
Offline