Hello, developers,
SQuirreL 4.8.0 has a nice feature "Option to view contents of cell detail or cell data popup as image." When it is not in pop-up window, it looks like persistent (within browsing particular ResultSet) setting, which is great.
May I ask You to add to "Select display:(Default|Image)" - Allows to display the column content as image also XML and JSON, which will then show cell already formatted as XML and JSON? And not only for XML and JSON data type columns, but to any type, where can XML or JSON appear (varchar, CLOB, XML, JSON, other, unknown...).
It would be great to have XML and JSON data formatted out of the box (based on setting of Select display control), so we can bypass always clicking on Reformat Xml/Json button. If the formatting function would fail to format data, then normal string will be shown (supress any Unable to format message).
This feature would enable fast browsing by XML and JSON data formatted cells using just up and down arrows or mouse clicking.
Thank You very much, Stepan
The following behavior was implemented and will be available in future snapshots and versions (excerpt from change log):
'#617 | https://github.com/squirrel-sql-client/squirrel-sql-code/issues/41
SQL result table: The detail data display now allows to automatically reformat XML or Json data.
To configure automatic reformatting go to menu File --> Global preferences
--> tab "Data type controls" --> section General
Note: For detail data display double click a table cell or switch on cell detail display.
Furthermore the reformat button was made a toggle button which allows to switch back to the unformatted data.
Gerd, I downloaded "squirrel-sql-snapshot-20241023_2105-standard.jar" at Thursday morning and we tested it in our team for two days and it works perfectly. Thank You very much for this change. You can close this RFE as "implemented". Regards, Stepan
Closed as requested.