I have a collection that has a createdAt field in it. When I get multiple documents from this collection, I use this field to sort them from the newest to the oldest. The thing is, that multiple documents can somehow…
I want to create product filter for multiple categories. User will select for ex. Mobile phones category via form select element and then there will be showed options for this category which user can choose, for ex. Color, processor,... And…
The problem is that when using order_by(), Ukrainian letters are incorrectly sorted alphabetically, that is, before "а", "б" is placed "і" and "є".
This is my first question on stackoverflow. I have problem with sorting posts. I write small plugin to sort posts alphabetically. It's work ok. There is a code: function wpb_custom_query( $query ) { if( $query->is_main_query() AND !($query->is_home()) ) { $query->set(…
I have a collection test, and a compound index on it with two fields db.test.createIndex({ i: 1, j: 1 }) When I execute following pipeline db.test.aggregate([{ $sort: { i: 1, j: 1 } }], { allowDiskUse: false }) it works…
We have a column in a PostgreSQL table with the following data: 1A 1ABCD 1B ABCD1 2 ABCD2 3 ABCD3 ABCD4 ABCD5 ABCD10 ABCD11 ABCD1111 A B Expected result after sorting: 1 2 3 1A 1ABCD 1B A B ABCD1…
I was able to write an even faster sort for integers! It sorts faster than the array can be generated. It works by declaring an array to be of length equal to the max value of the integer array to…
I'm trying to sort list by frequency and then by name (pandas 1.3.2, python 3.10). Firstly, I count each occurence in list, then, if amount is equal, names must be ordered alphabetically. I found out that all works when len(list)…
I'm trying to sort a file by second column, but in reverse order. I tried: sort -k2n -r file.txt The output is not in reverse order, so it seems -r is being ignored. I'm in CentOS.
I have "bank account" documents in a collection "economy" for a game in this format: _id: ObjectId("62a5c5d741c1059e0f498c2c") guild: 98525515134318336 user: 595415131438508070 balance: 156 bank: 100 I want to sort all of the documents that have the same guild value by…