MongoDB: Check if value is null or array is empty


Gerso 77

I want to match all documents that do not contain a "Company" property or an empty or empty array of "Company" values.

User.find({Company: {$in: [null, [] ]}}, function (err, users) {
      if (err) { throw err; }
      console.log(users.length);

}).then(function(doc) {
      console.log("finish User Company");
});
Gregory Newt

You can check each condition using query operators:$or

{
  $or: [{
    // Check about no Company key
    Company: {
       $exists: false
    }
  }, {
    // Check for null
    Company: null
  }, {
    // Check for empty array
    Company: {
       $size: 0
    }
  }]
}

Related


MongoDB: Check if value is null or array is empty

Gerso 77 I want to match all documents that do not contain a "Company" property or an empty or empty array of "Company" values. User.find({Company: {$in: [null, [] ]}}, function (err, users) { if (err) { throw err; } console.log(users.length); }).

MongoDB: Check if value is null or array is empty

Gerso 77 I want to match all documents that do not contain a "Company" property or an empty or empty array of "Company" values. User.find({Company: {$in: [null, [] ]}}, function (err, users) { if (err) { throw err; } console.log(users.length); }).

Hamcrest check if value is null or empty array

Nikolai Golub : I have a code that returns JSON where one of the fields may be null or an empty array. I have the following code to check: import static org.hamcrest.core.AnyOf.anyOf; import static org.hamcrest.CoreMatchers.nullValue; import static org.hamcres

Check if seekbar value is null or empty

artist I am trying to check if the value of seekbar is less than 0. Currently my seekbar has a value between 0-9. seekbar1 = (SeekBar)findViewById(R.id.sb); seekbar1.setOnSeekBarChangeListener( new OnSeekBarChangeListener(){ @Override public void onPr

Check if property value is null or empty

· 鲍德尔 (Bishnu Paudel I'm having trouble processing JSON data with PHP in Oracle RightNow CRM. Example json is included below. When I try to check the if condition, the data contained in the "person.private_email" property only evaluates to true if some data is

Check if seekbar value is null or empty

artist I am trying to check if the value of seekbar is less than 0. Currently my seekbar has a value between 0-9. seekbar1 = (SeekBar)findViewById(R.id.sb); seekbar1.setOnSeekBarChangeListener( new OnSeekBarChangeListener(){ @Override public void onPr

Check if property value is null or empty

· 鲍德尔 (Bishnu Paudel I'm having trouble processing JSON data with PHP in Oracle RightNow CRM. Example json is included below. When I try to check the if condition, the data contained in the "person.private_email" property only evaluates to true if some data is

Check if property value is null or empty

· 鲍德尔 (Bishnu Paudel I'm having trouble processing JSON data with PHP in Oracle RightNow CRM. Example json is included below. When I try to check the if condition, the data contained in the "person.private_email" property only evaluates to true if some data is

Check if object array value is empty

Samuel Sharp How to check if an object array value is empty? In this case I want to check if the price value is empty E.g available_cars:{ cars:[ {name:"BMW", price:2000000} {name:"Volkswagen", price:1500000} {name:"Audi", price:null} ] } spectrum Use Array.s

MongoDB empty string value vs null value

South Ruan In MongoDB production, if the value of a key is empty or not provided (optional), an empty string value should be used or null should be used as the value. 1) Are there any pros and cons between using empty strings and null? 2) What are the advantag

MongoDB empty string value vs null value

South Ruan In MongoDB production, if the value of a key is empty or not provided (optional), an empty string value should be used or null should be used as the value. 1) Are there any pros and cons between using empty strings and null? 2) What are the advantag

Check if value of document is in array MongoDB

Xge I have about 200,000 documents in a collection like this: { "_id": "tdhABqSZPEZ2fFcEzOVCb-q8d", "user": "testuser", "content": "Test Content" } I have an array with about 50,000 entries: let arr = ["tree", "apple", "test", "orange", ...otherEntries] //

How to check if value in JS is not null and not empty string

mistery_girl: Is it possible to check if a value is not null and not an empty string in Java? I am using one of the following: var data; //get its value from db if(data != null && data != '') { // do something } But I wonder if there is another better sol

jQuery: Check if the value of a field is empty (null)

ziiweb : Is this a good way to check the value of a field null? if($('#person_data[document_type]').value() != 'NULL'){} Or, is there a better way? Ancient method: The value of the field cannot be null, it is always a string value. This code will check if the

How to check if a value is empty, or null in JavaScript?

Mr Robot: I have a problem trying to get data from the state, 2 values appear in console.log. I want to remove null values, but I've exhausted all methods. How to remove a null value? class DetailOrderTracking extends Component { constructor(props) {

Check if value in angular template is not empty and not null?

username How to check if value is not empty and not null. In the controller:$scope.data.variable = 'some valid data'; <div ng-if="data.variable != ''">something else</div> thanks AWAY Because both null and empty are falsy values div.variable if not nullor empt

How to check if value in JS is not null and not empty string

mistery_girl: Is it possible to check if a value is not null and not an empty string in Java? I am using one of the following: var data; //get its value from db if(data != null && data != '') { // do something } But I wonder if there is another better sol

Check if value in angular template is not empty and not null?

username How to check if value is not empty and not null. In the controller:$scope.data.variable = 'some valid data'; <div ng-if="data.variable != ''">something else</div> thanks AWAY Because both null and empty are falsy values div.variable if not nullor empt

jQuery: Check if the value of a field is empty (null)

ziiweb : Is this a good way to check the value of a field null? if($('#person_data[document_type]').value() != 'NULL'){} Or, is there a better way? Ancient method: The value of the field cannot be null, it is always a string value. This code will check if the

How to check if a value is empty, or null in JavaScript?

Mr Robot: I have a problem trying to get data from the state, 2 values appear in console.log. I want to remove null values, but I've exhausted all methods. How to remove a null value? class DetailOrderTracking extends Component { constructor(props) {

Check model value is null or empty in javascript

Ze this is my code <script> var _getValue = @myViewModel.myInfo.Name == null ? 'isNull' : 'notNull'; </script> @myViewModel.myInfo.NameThe value in the database is empty, but this code always returns notNull. How can I properly check for null or null? Niti

Check if value in angular template is not empty and not null?

username How to check if value is not empty and not null. In the controller:$scope.data.variable = 'some valid data'; <div ng-if="data.variable != ''">something else</div> thanks AWAY Because both null and empty are falsy values div.variable if not nullor empt

Check if value in angular template is not empty and not null?

username How to check if value is not empty and not null. In the controller:$scope.data.variable = 'some valid data'; <div ng-if="data.variable != ''">something else</div> thanks AWAY Because both null and empty are falsy values div.variable if not nullor empt

How to check if value in JS is not null and not empty string

mistery_girl: Is it possible to check if a value is not null and not an empty string in Java? I am using one of the following: var data; //get its value from db if(data != null && data != '') { // do something } But I wonder if there is another better sol

jQuery: Check if the value of a field is empty (null)

ziiweb : Is this a good way to check the value of a field null? if($('#person_data[document_type]').value() != 'NULL'){} Or, is there a better way? Ancient method: The value of the field cannot be null, it is always a string value. This code will check if the

How to check if a value is empty, or null in JavaScript?

Mr Robot: I have a problem trying to get data from the state, 2 values appear in console.log. I want to remove null values, but I've exhausted all methods. How to remove a null value? class DetailOrderTracking extends Component { constructor(props) {

Check if value in angular template is not empty and not null?

username How to check if value is not empty and not null. In the controller:$scope.data.variable = 'some valid data'; <div ng-if="data.variable != ''">something else</div> thanks AWAY Because both null and empty are falsy values div.variable if not nullor empt

Check if an array value is set to null

Bartek Kosa How to check an array variable $a = array('a'=>1, 'c'=>null); Set to null. function check($array, $key) { if (isset($array[$key])) { if (is_null($array[$key])) { echo $key . ' is null'; } echo $key . ' is se