The sorting operation within the data grid is not scalable. Rather, it is simply provided as a convenient feature for smaller datasets (containing less than 1000 records). When working with larger datasets, consider using the Sort Rows node.

Slow data sorting is also compounded by the fact that this operation is temporary. When you close the View window, all the sorting results are lost and you need to reproduce the corresponding actions from scratch to achieve the desired appearance. Again, the Sort Rows node is the best solution that allows users to keep the specified sorting order.

If you are strictly determined to sort data within the View window after all and want to speed up the sorting operation, open the Properties window of the node, navigate to the General tab and check the Staged option. Then re-execute the node. Enabling the Staged option makes PolyAnalyst skip the optimization step it normally performs to efficiently store the derived data. Instead, full copies of the derived values are saved. In this case, the sorting algorithm can operate directly on the copies, and does not have to restore each original value. As a result, the execution is sped up. The major tradeoff, however, is that the staging considerably increases the amount of disk space used to store the node’s results.

Sometimes the results of the Sort Rows node may not correspond to your expectations. This is most likely due to the fact that the column you wish to sort is of the String data type and its sorting peculiarities. The String data type contains characters which can be alphabetical, numerical and punctuation characters.

The sorting of numerical and string columns is performed differently. When a list of numbers is sorted, the numbers are compared by their magnitude. When a list of strings is sorted, the characters are compared by their order according to the following sequence: abcdefghijklmnopqrstuvwxyz0123456789 (this is referred to as the "lexicographic order").

PolyAnalyst displays only the first 128 characters of the Text column within the data grid. This design increases the scalability of the grid as well as the performance of PolyAnalyst when users view or scroll through data. Internally, the entire value is stored. When you print, export or perform analysis, full values are used/displayed.

Contents of the records are usually displayed in full in the text panel above the data grid. If this pane is hidden, click the button on the toolbar. For more information, see the corresponding section.

In rare cases, when the data is being refreshed, the data grid may display N/A values in red font. This behavior is temporary – you just need to wait for the operation to be finished. The progress is indicated by the animated loading icon.

Most of the time this operation is completed within seconds, although it may take several minutes when you have poor connection to PolyAnalyst Server or when PolyAnalyst Server is under heavy load (performing several operations).

If an error is displayed in the text panel of the data grid, check your connection settings. This issue is generally related to the availability of ports described in detail in this section.

Whenever you set an HTTP or HTTPS connection port in the Administrative Tool, you also need to open it in the firewall. By default, PolyAnalyst prefers the connection via the HTTPS port. In case it is disabled (set to 0), the HTTP connection port is used.