New Single record pop-up view

Hello!

Would it be possible to add a piece of functionality that would allow to preview/edit single record of my choice in dedicated popup window, that would list all record's properties vertically?

My problem came from the experience of working with large Magento tables having hundreds of properties. Scrolling the table's Data view horizontally is annoying, because content scrolls so fast (because of the amount of columns), that it's really difficult to find the right column. Yes, I know I can filter the columns, but it not always matches my needs.

I imagine the popup would have a grid similar to the one from table columns configuration grid (attachment). First column (Name) would look exactly the same, but the second column would simply show the value with the same ability to edit as in Data grid. Consecutive colums could show the actual data length and type. In contrast to the table configuration grid, this one would allow sorting the columns by name. The popup could be opened by doubleclick on the record (currently this action is not doing anything) or via context menu.

It's the piece of functionality I've been waiting for years. Maybe it's time for my dreams to come true? :)

Cheers, Matt

I suppose issue #369 is similar.

Hey!

No, I don't think so. I can't find any similarity. The other guy requested ASCII text grid which is just another repsesentation of table Data grid capable of presenting many records simultanously, while the feature I'm suggesting is still regular GUI grid view, just presenting single record at once, and transposed (each grid row is dedicated to single column/field) - very similar to the table stucture grid view (my screenshot).

Hey!

No, I don't think so. I can't find any similarity. The other guy requested ASCII text grid which is just another repsesentation of table Data grid capable of presenting many records simultanously, while the feature I'm suggesting is still regular GUI grid view, just presenting single record at once, and transposed (each grid row is dedicated to single column/field) - very similar to the table stucture grid view (my screenshot).

OK, well actually the part of his post starting at "As record view is displayed like this:" would be more or less the same functionality.

I am also missing functionality that @maniek described. I used it in other sql clients so its not something unseen.

It corresponds to the \G modifier of mysql command line client.

Best regards and thanks for a great app.

You can see in the attachment an example of such view from PhpStorm (it's called "Transposed view" there).