• English

      • Sort Field

      Collection field: SortCommunity Edition+

      Introduction

      Sort fields are used to sort records in a collection, supporting sorting within groups.

      Warning

      Since the sort field is part of the same collection, a record cannot be assigned to multiple groups when using group sorting.

      Installation

      Built-in plugin, no separate installation required.

      User Manual

      Create a Sort Field

      20240409091123_rec_

      When creating sort fields, the sort values will be initialized:

      • If group sorting is not selected, initialization will be based on the primary key field and creation date field.
      • If group sorting is selected, the data will be grouped first, and then initialization will be based on the primary key field and creation date field.
      Explanation of Transaction Consistency
      • When creating a field, if the sort value initialization fails, the sort field will not be created.
      • Within a certain range, if a record moves from position A to position B, the sort values of all records between A and B will change. If any part of this update fails, the entire move operation is rolled back, and the sort values of the related records will not change. :::

      Example 1: Create the sort1 field

      The sort1 field is not grouped.

      20240409091510

      The sort fields of each record will be initialized based on the primary key field and creation date field.

      20240409092305

      Example 2: Create a sort2 field based on Class ID grouping

      20240409092620

      At this time, all records in the collection will be grouped first (grouped by Class ID), and then the sort field (sort2) will be initialized. The initial values of each record are:

      20240409092847

      Drag-and-Drop Sorting

      Sort fields are mainly used for drag-and-drop sorting of records in various blocks. The blocks that currently support drag-and-drop sorting include tables and boards.

      :::warning

      • When the same sort field is used for drag-and-drop sorting, using it across multiple blocks may disrupt the existing order.
      • The field for table drag-and-drop sorting cannot be a sort field with a grouping rule.
        • Exception: In a one-to-many relationship table block, the foreign key can serve as a group.
      • Currently, only the board block supports drag-and-drop sorting within groups. :::

      Drag-and-Drop Sorting of Table Rows

      Table block

      20240409104621_rec_

      Relationship table block

      :::warning In a one-to-many relationship block:

      • If an ungrouped sort field is selected, all records may participate in the sorting.
      • If records are first grouped by the foreign key and then sorted, the sorting rule will only affect the data within the current group.

      The final effect is consistent, but the number of records participating in the sort is different. For more details, see Sorting Rule Explanation.

      Drag-and-Drop Sorting of Board Cards

      20240409110423_rec_

      Sorting Rule Explanation

      Displacement between ungrouped (or same-group) elements

      Suppose there is a set of data:

      [1,2,3,4,5,6,7,8,9]

      When an element, say 5, moves forward to the position of 3, only the positions of items 3, 4, and 5 change. Item 5 takes the position of 3, and items 3 and 4 each shift back one position.

      [1,2,5,3,4,6,7,8,9]

      If we then move item 6 backward to the position of 8, item 6 takes the position of 8, and items 7 and 8 each shift forward one position.

      [1,2,5,3,4,7,8,6,9]

      Movement of elements between different groups

      When sorting by group, if a record is moved to another group, its group assignment will also change. For example:

      A: [1,2,3,4]
B: [5,6,7,8]

      When item 1 is moved after item 6 (the default behavior), its group will also change from A to B.

      A: [2,3,4]
B: [5,6,1,7,8]

      Sort changes are unrelated to the data displayed on the interface

      For example, consider a set of data:

      [1,2,3,4,5,6,7,8,9]

      The interface only displays a filtered view:

      [1,5,9]

      When item 1 is moved to the position of item 9, the positions of all intermediate items (2, 3, 4, 5, 6, 7, 8) will also change, even though they are not visible.

      [2,3,4,5,6,7,8,9,1]

      The interface now displays the new order based on the filtered items:

      [5,9,1]