Tab "Data"

[expired user #9193]'s profile image [expired user #9193] posted 9 years ago in General Permalink
Hello,

after many frustrating days, i have seen that the tab "data" in a table dont show ALL rows in a table, instead it guess and show some example rows.

I thought the data- tab shows all rows in the table, like a select * from table.

Is there a way to change the settings there? If i click on data tab i want to see exactly ALL rows

Thanks a lot
[expired user #6512]'s profile image [expired user #6512] posted 9 years ago Permalink
You can view the executed queries in the query-log on the bottom of the screen.
By default there shouldn't be a filter active but pagination is turned on by default so you might not see everything depending on the size of your table.
ansgar's profile image ansgar posted 9 years ago Permalink
You can press the "Show all" button on the top right.

Additionally, you can modify the number of rows to load at once, in Tools > Preferences > Text formatting > "Number of rows displayed in data tab"
[expired user #9193]'s profile image [expired user #9193] posted 9 years ago Permalink
AAAHHHH great, "Show all" was the hint!

Is there a way to make "Show all" as Default Setting?
ansgar's profile image ansgar posted 9 years ago Permalink
No. But you can set the "number of rows to display" to some millions.

Please login to leave a reply, or register at first.