Order by
In data comparison window, you can filter a table (WHERE) but you cannot sort the data shown on the resulting grid after the data comparison (ORDER BY).
1
vote
Nick A.
shared this idea
AdminDevart
(_, Devart)
responded
To perform comparison, dbForge reads out data to the cache. It can’t sort the data, because, to display in the resulting grid, dbForge reads the data from the cache upon scrolling and doesn’t keep it in the grid in order to avoid out of
memory errors.
-
Nick A.
commented
In the same way as the "WHERE" field is applied to the initial query, a new "ORDER BY" field could also be applied. Is it possible?
-
Nick A.
commented
Sorting could be allowed if the grid contains a small number of rows. You could set a 1000 rows hard-limit.