|
Replies:
1
-
Pages:
1
-
Last Post:
Feb 28, 2011 11:17 AM
by: Guest
|
|
|
Posts:
2
Registered:
2/28/11
|
|
|
|
Direct Sorting with Limit
Posted:
Feb 28, 2011 2:42 AM
|
|
|
I would like to use Toad for MySQL but i need help with the following thing:
When i open the data view of a table i want to sort it by on the column names.
I have a table with 10000 record an want to view it with 300 record per page.
Lets asume i have one column with the number from 10000 till 20000.
NOW: when i click on the column name the table gets sortet within the 300 records on the page. So when i want to sort DESCENDING i see 10299, 10298, 10297 ...
WHAT I NEED: the sorting should by done directly by the database so i get the 300 first records of all 10000 sorted by the column i clicked. So when i want to sort DESCENDING i see 20000, 19999, 19998 ...
It would also be great when null values would be somehow displayed as null value and not an empty field.
Which settings do i have to change to set this up?
I already tried to find something in the manual but i didn't find anything.
|
|
|
|
|
|
|
Re: Direct Sorting with Limit
Posted:
Feb 28, 2011 11:17 AM
in response to: Shodantos
|
|
|
You can do this using the filter button (It's on the top left toolbar of the data view tab).
Null values should already be shown as {null} (They are on my build).
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
