Skip to content

DisplayOrderHelper.ReorderValues method (1 of 2)

Sets a records display order to to requested value, and also renumbers other records in the group as required.

public static bool ReorderValues(IDbConnection connection, IDisplayOrderRow row, 
    ICriteria? filter = null, object? recordID = null, int newDisplayOrder = 1, 
    bool descendingKeyOrder = false, bool hasUniqueConstraint = false, bool preserveGaps = false)
parameter description
connection Connection (required).
row Row with a display order and ID field (should implement IDbIdRow interface).
filter Filter that will determine the record group (can be null).
recordID ID value of the record.
newDisplayOrder New display order of the record.
descendingKeyOrder Will records with same display order values be sorted in ascending or descending ID order? For example, if records with ID's 1, 2, 3 has display order value of "0", their actual display orders are 1, 2 and 3. If this parameter is set to true (descending), their display orders will become 3, 2, 1. This parameter controls if records that are added recently and has no display order value assigned (or 0) be shown at start or at the end.
hasUniqueConstraint True if the display order field has a unique index
preserveGaps When false (default) all display order values in the group are normalized to consecutive values starting from 1, closing any gaps. When true, only the records between the old and the new position are renumbered and the existing display order values (including any gaps) are preserved where possible, so fewer rows are updated.

Return Value

If any of the display order values is changed true.

See Also

DisplayOrderHelper.ReorderValues method (2 of 2)

Sets a records display order to to requested value, and also renumbers other records in the group as required.

public static bool ReorderValues(IDbConnection connection, string tableName, Field keyField, 
    Field orderField, ICriteria? filter = null, object? recordID = null, int newDisplayOrder = 1, 
    bool descendingKeyOrder = false, bool hasUniqueConstraint = false, bool preserveGaps = false)
parameter description
connection Connection (required).
tableName Table name (required).
keyField ID field meta that will be used to locate the record (required).
orderField Display order field meta.
filter Filter that will determine the record group (can be null).
recordID ID value of the record.
newDisplayOrder New display order of the record.
descendingKeyOrder Will records with same display order values be sorted in ascending or descending ID order? For example, if records with ID's 1, 2, 3 has display order value of "0", their actual display orders are 1, 2 and 3. If this parameter is set to true (descending), their display orders will become 3, 2, 1. This parameter controls if records that are added recently and has no display order value assigned (or 0) be shown at start or at the end.
hasUniqueConstraint True if the entity has a unique constraint on display order column.
preserveGaps When false (default) all display order values in the group are normalized to consecutive values starting from 1, closing any gaps. When true, only the records between the old and the new position are renumbered and the existing display order values (including any gaps) are preserved where possible, so fewer rows are updated.

Return Value

If any of the display order values is changed true.

See Also

Previous Page Next Page