Sorting
Feature Description
Sorts the dataset based on field values and saves the sorted result as a new dataset.
Special Notes:
- This tool is only applicable to: UDB/UDBX, database datasource.
- Different databases may have variations in sorting results for certain data types, which originate from the database's own behavior. Here are two examples: (1) UDBX sorts Chinese characters based on Unicode encoding, while PostGIS sorts Chinese characters depending on the database's locale setting. For example, if the locale setting is Chinese UTF-8 (zh_CN.UTF8), the sorting rule for Chinese characters will be based on the first letter of pinyin. In this case, UDBX and PostGIS will have inconsistent sorting results for the same Chinese characters. (2) Similarly, when UDBX and PostGIS have different sorting rules for special symbols (~!@#$%^&*()-_=+|[{}];:,<.>/?), the sorting results will also differ.
Parameter description
| Parameter Name | parameter interpretation | parameter type |
|---|---|---|
| Datasource | Specifies the datasource where the dataset to be sorted is located. | Datasource |
| Dataset | Specifies the source dataset to be sorted. | DatasetVector |
| sort field | Specifies the sort field. | OrderByField[] |
| sort order | Each sort field needs to set the corresponding sorting method, including ascending and descending order. | OrderByField[] |
| patial field sorting method | Specifies the patial field sorting method, supporting top-right, top-left, bottom-right, and bottom-left sorting, with top-right as the default. This parameter is invalid if the sort field is not filled. Currently, the patial field sorting method only supports UDBX and PostGIS datasources. |
GeoFieldSortMethodEnum |
| target datasource | Specifies the datasource for storing the result dataset. | Datasource |
| the name of the resulting dataset | The result dataset after sorting the fields. | String |
| Whether to overwrite an existing dataset (optional) | If a dataset with the same name exists in the target datasource, whether to overwrite it. Check to overwrite; if not checked, it will fail to execute when a dataset with the same name exists, and by default, it is not checked. | boolean |
Output Result
| Parameter Name | parameter interpretation | parameter type |
|---|---|---|
| target dataset | The result vector dataset. | DatasetVector |