Here are some example MongoDB records:
[
{first: "Sample", middle: "X", last: ""},
{first: "Sample", middle: "Y", last: ""},
{first: "Sample", middle: "", last: "Z"},
{first: "Sample", middle: "W", last: ""}
]
Results:
If .arrange({middle:1,last:1}) =====> Z,X,Y,W
If .sort({last:1, middle:1}) =====> X,Y,W,Z
If [how about this ? ] =====> X,Y,Z,W
The issue at hand is attempting to sort on two fields, utilizing one if the other is empty. Unfortunately, a straightforward sort operation cannot accomplish this since it follows a sequential order based on each field individually.
To address this challenge, a multi-step query must be performed. Firstly, manipulate the data to create a new sorting field that prioritizes last names and resorts to middle names when last names are missing. Subsequently, execute the sort operation based on this newly established field.
One downside of this method is the decreased effectiveness of indexes, resulting in suboptimal performance particularly with larger datasets.
An alternative approach would involve rectifying the data integrity by ensuring that no records contain blank last names. In cases where last names are not provided, transferring the middle name into the last name field would prevent such issues from arising.
If you're looking to manipulate your data in a specific way, consider utilizing the aggregation framework. This will allow you to reformat your data for sorting purposes. Take a look at the example aggregation query below:
db.yourCollection.aggregate(
[
{$project:
{
first: 1,
rest: {$cond: [{$eq: ['$middle', '']}, '$last', '$middle']},
isMiddle: {$cond: [{$eq: ['$middle', '']}, false, true]}
}
},
{$sort: {rest: 1}},
{$project:
{
first: 1,
middle: {$cond: ['$isMiddle', '$rest', '']},
last: {$cond: ['$isMiddle', '', '$rest']}
}
}
]
)
By using this aggregation method, you can achieve the desired sorting outcome:
{ "first" : "Some", "middle" : "A", "last" : "" }
{ "first" : "Some", "middle" : "B", "last" : "" }
{ "first" : "Some", "middle" : "", "last" : "C" }
{ "first" : "Some", "middle" : "D", "last" : "" }
The typical sorting process treats the keys 'middle' and 'last' as separate entities, leading to independent sorting. To overcome this limitation, combining them into a single key through aggregation is necessary.
I have discovered a viable solution.
db.getCollection('dummy').aggregate(
[
{ $project: { merge: { $concat: [ "$middle", "$last" ] },middle: '$middle',last:'$last' } }
]
).result.sort(function(a, b) {
return a.merge > b.merge ? 1 : -1;
})
My challenge is to fetch the Max value and Percent value into a jQuery function. I attempted to retrieve these values using hidden variables and Session variables on page load, but they always return 0. Here are the properties: public static int Max { ...
I am attempting to utilize the reduce method to generate an object that displays the percentage of occurrence of different countries in a given list. Input: countriesList = ["US","US","US","UK","IT"," ...
I am looking to create a donut sparkline chart in my React application using Highcharts. Can anyone guide me on how to achieve this functionality within React? My goal is to generate a visualization like the following, illustrating the percentage of a cer ...
I recently started working with node.js and I'm currently working on a side project that I'm having some trouble with. My goal is to extract values from a specific column in an unzipped csv file and then add them up using node.js. Below is my co ...
Just started experimenting with Angular 2 and encountering an issue when importing zone.js as a global variable: https://i.stack.imgur.com/gUFGn.png List of my packages along with their versions: "dependencies": { "angular2": "2.0.0-beta.3", "es ...
At this moment, my Vue.js component is retrieving data from an Elasticsearch query and displaying it in a list like this: <li v-for="country in countries">{{ country.key }}</li> The issue I am facing is that I want to show users only a snippe ...
I am currently working on updating a single property. I have various properties such as product name, price, quantity, supplier, and description. When sending the updated quantities along with all properties to MongoDb, I am able to update both the databas ...
I have a website where I've implemented an AJAX pagination system. Additionally, I've included a JQUERY call to add a class to certain list items within my document ready function. $(document).ready(function(){ $(".products ul li:nth-child(3 ...
I encountered an issue with my code. It functions properly, but when I introduce new elements into the dom, it fails to show or hide them. jQuery("div.cat-icon").on({ mouseenter: function () { jQuery(this).find('.catselect').show( ...
I'm intrigued by the relationship between Node.js and Express. Here is my Node.js server creation code: const https = require('https'); const fs = require('fs'); const options = { key: fs.readFileSync('./https1/key.pem&ap ...
Working with highlight.js to include a custom CSS code, however, this library automatically adds span tags around the desired text For example: <pre> <code class="language-css hljs" contenteditable="true" id="css-code&quo ...
var slider = new Slider('#slider1',{ tooltip: 'always' }); //generate a password function passwordGenerator () { // how long is the password going to be? var passwordLength = document.getElementById('slider1').value; ...
My app has a unique feature where it displays different dropdown lists based on previous selections. Specifically, I have two lists - one for vehicle Makes and the other for Models. When a specific Make is chosen, like BMW or Audi, the next list will only ...
Currently, I'm facing an issue with passing variables to a PHP script using onclick. It seems that I am making a mistake somewhere. To demonstrate the problem, let's say I have the following code snippet in my main page: <img src="myImage.jp ...
I am looking for guidance on how to modify the value of an input in a form that contains multiple data entries. Here is my form: <form method="post" action="pax-flight.php#pax-flight" class="paxform"> <input type="hidden" value="{"data":{"us ...
I am currently utilizing PrimeFaces and have a p:inputText field that requires updating certain components on the view based on the most recent keystroke within that p:inputText. Below is the code snippet: <p:inputText value="#{customerLController.surn ...
I've been trying to select a specific node using two not clauses, but so far I haven't had any luck. What I'm attempting to achieve is selecting an element whose div contains the string 0008, but it's not 10008 and also does not contain ...
As a newcomer to web development, I am facing the following challenge: I have three models in my application: products class Product < ApplicationRecord has_and_belongs_to_many :steps end steps class Step < ApplicationRecord has_and_belongs_ ...
I am attempting to retrieve 2 numbers as arguments for the function saveQuestion, however, I'm encountering an issue. $("#questionRow") .append('<input type="submit" class="btn btn-default" id="saveQuestion' + addSectionCount + & ...
I need to implement a feature where users can select a company and then an employee from that company. I came across a similar question on this link, but I specifically want both inputs to be autocomplete-enabled. This is the code snippet I currently have ...