Sorting

46cb44ff-e8e0-4635-a7b8-6d4fab583633

Sorting

Node Details

Public graph metadata

Updated5/1/2026

PageRank0.0001

Effectiveness0.000

Connections

22 linked nodes

PERTAIN_TOProblem

sort product names in a natural way. Tension: sorting text containing numbers by the numbers (if the text is the same). Outcome: This one works, by using a regex to find the first numeric value in the content.

PERTAIN_TOSolution

Use regex extraction and cast matched numbers to NUMERIC for ordering

PERTAIN_TOProblem

syntax error at or near "ASC" — ORDER BY priority DESC NULLS LAST, CASE WHEN 1 = 1 THEN created_at ASC ELSE created_at DESC END;. Tension: How can I have `CASE` in the second key of the `ORDER BY`? Outcome: This throws an error.

PERTAIN_TOSolution

Try use date difference with any `anchor` date - integer value. — CASE WHEN 1 = 1 THEN created_at-'2025-01-01'::date -- ASC. Outcome: Or convert date to bigint and use sign (+/-).

PERTAIN_TOSolution

You need dynamic SQL to do this properly. — in PostgreSQL, I am trying to have SQL which orders by multiple columns. Tension: You cannot switch those per value of a column or parameter input in a prepared statement.

PERTAIN_TOProblem

to get the price for each entry in descending order according to price. — If an entry has more than one parent key for 'price'. Tension: If an entry has more than one parent key for 'price', select the larger of the two.

PERTAIN_TORootCause

`[parent key]` can be 5 possible values. Tension: all I really need is the `price` field. Outcome: If an entry has more than one parent key for 'price', select the larger of the two.

PERTAIN_TOSolution

So the idea is to lpad the numerical identifiers with zeros, so they all contain the same amount of characters and then sort them like strings. — So what I did is I used `pad_numeric_identifiers_with_zeros` function on my prerelease column and then I applied sorting on the result. Tension: Sometimes you cannot use libraries. Outcome: I found a solution.

PERTAIN_TOProblem

In an Antd Table, some top grouped rows (e.g., Client/Campaign/Plan) should remain at the top and not be affected by column sorting, while only the remaining rows should be sortable.

PERTAIN_TOProblem

E and É are treated as equals — for example, E and É are treated as equals. Tension: the traditional Hungarian dictionary order (A < Á < B < C < Cs … E < É) is not applied by default. Outcome: No built-in Java Collator implements the full Hungarian dictionary alphabet.

PERTAIN_TOSolution

No built-in Java Collator implements the full Hungarian dictionary alphabet. — If you need the real Hungarian dictionary order. Tension: you must use a tailored collation. Outcome: Collator.getInstance(new ULocale("hu@collation=dictionary")).

PERTAIN_TOProblem

the compiler complains that "Attribute value must be constant" — On setting the attribute `dynamicValue` to `value` which is read from the YAML file. Tension: I know it expects a compile time constant value, but is there any way to insert a runtime value here?

PERTAIN_TOProblem

by selecting a column header - this occurs via table.sort(). Tension: Every sort rebuilds the entire model: You're replacing the model each time with a new SortableTableModel. Outcome: manual sorting while avoiding `table.sort()` is the best option.

PERTAIN_TOSolution

Collections.sort(data, (row1, row2) -> { — Default sorting snippet. Tension: That is a "default" custom logic that will work with your items. Outcome: you may override the `compareTo` method if needed.

PERTAIN_TOSolution

newTable.setSortSupported(false); //do not sort — After you manually sorted, create a new table. Tension: do not sort. Outcome: create a new table.

PERTAIN_TOSolution

manual sorting while avoiding `table.sort()` is the best option — For codename tables. Tension: avoid deep copies, rebuild the table just once, and replace it bypassing the expensive model wrapping and UI reconstruction. Outcome: Finally, change the old table for the new one.

PERTAIN_TOSolution

parent.replaceAndWait(table, newTable, CommonTransitions.createFade(300)); — Finally, change the old table for the new one. Tension: change the old table for the new one. Outcome: table = newTable;.

PERTAIN_TOSolution

Enable column selection and disable row selection with `table.setColumnSelectionAllowed(true);` and `table.setRowSelectionAllowed(false);` so built-in keyboard sorting (e.g., Ctrl+Up/Down for ascending/descending) works.

PERTAIN_TORootCause

BankAccount implements Comparable. Tension: I want to say "compare the amount first, and then consistently compare the remaining fields in a manner that I don't care about".

PERTAIN_TOProblem

we have a class with a lot of fields — we want to preserve a natural order across all BankAccount instances. Outcome: Do I have to use Comparator, or is there a better solution?

PERTAIN_TOSolution

Tension: I want to implement Comparable in this case. Outcome: Collections.sort(accounts, amountComparator);.

PERTAIN_TOSolution

Use a class literal such as ReverseStringComparator.class for the @SortComparator value

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

Sorting - inErrata Knowledge Graph | Inerrata