Visualize data structures
When debugging, JetBrains Rider lets you visualize data structures in your code:
Strings that contain HTML, XML, JSON, and JWT can be displayed with the proper formatting
Variables that hold array-, collection-, and query-like structures can be explored in a tabular form
This helps you quickly understand the structure, contents, and transformations of your data. It simplifies the process of understanding complex patterns in your code, which ultimately enhances your debugging efficiency.
To visualize your data, click View or Explore next to the corresponding variable in the Debug window:
Here is an example of a two-dimensional array being visualized:
Here is an example of a JSON string being visualized:
Imagine that in the debugging context you have orders variable that contains the results of a database query, and you want to study the contents of this variable. One way to approach this would be to use the Evaluate Expression dialog and write different expressions involving orders.
A much more convenient way is to explore the contents visually in a tabular view. To do so, we can locate the orders variable in the Debug window and click Explore next to it:
This will open the Collection view dialog displaying the variable contents:
The dialog works as a familiar table viewer with all typical features.
Set a number of rows in the result set
By default, when you issue a query, the number of returned rows is limited to 500. This limitation is introduced to avoid an overload (for example, when your
SELECTstatement returns one million rows).To change this limit, open settings Ctrl+Alt+S and navigate to . In the field, specify a new number. To disable the limitation, clear the Limit page size to checkbox.
Click the current row range in the grid pagination control and select the desired value from the Page Size list.
Depending on the value of the Limit page size to parameter, the result set might be divided into several pages. For example, you set the Limit page size to parameter to 100, but your query returned 200 rows. You will have two pages of rows, with 100 rows on each page.
Navigate between subsets of rows
To navigate between pages, use the following controls:
First Page: Navigates to the first page of the result set.
Previous Page: Navigates to the previous page of the result set.Alternatively, press Ctrl+Alt+Up.
Next Page: Navigates to the next page of the result set.Alternatively, press Ctrl+Alt+Down.
Last Page: Navigates to the last page of the result set.
Search, examine, filter, and sort the data
To find textual occurrences on the current page, press Ctrl+F or click Find on Current Page
, and then use the text field and search options that appear.To examine the data in specific sells, click a cell or click multiple cells while holding down Ctrl. The selected object will be displayed on the right.
To filter the data globally, write a query in the filter area above the table.
To filter data in specific rows, click Enable Local Filter on the toolbar, and then use the filter icons that appear on the column headers.
To sort data rows by a specific column value, click the corresponding column header.
Export data to a file
Click Export Data on the toolbar.
Configure export preferences and click Export to File.
