Searching for a specific string within a nested array in a JSON object using JavaScript loops

Question

Searching for a specific string within a nested array in a JSON object using JavaScript loops

I'm struggling to loop through a JSON array with subarrays to find the user whose username is 'admin'. Once I locate this user, I want to create a new JSON array containing their data (region, sport, city, etc.). I am unsure how to implement this logic within a loop and extract the relevant information. My apologies for the seemingly basic question, but I could use some guidance in this matter.

Here is an example of the JSON array structure:

[
    {
        "_id": "5520f52e2c0a22541541bde1",
        "region": {
            "_id": "551e6779d8f1afa01bd86529",
            "name": "region_name"
        },
        "user": {
            "_id": "551a938af056a7fc099879c1",
            "firstName": "John",
            "lastName": "Boo",
            "username": "admin",
            "id": "551a938af056a7fc099879c1"
        },
        "__v": 0,
        "sport": [
            {
                "_id": "551e69c6d8f1afa01bd86533",
                "name": "Running"
            }
        ],
        "city": "some_city",
        "advert": "some_advert",
        "title": "I want to run!",
        "created": "2015-04-05T08:41:18.173Z"
    },
    {
        "_id": "552010740628cab002b3a700",
        "region": {
            "_id": "551e67b6d8f1afa01bd8652f",
            "name": "region_name"
        },
        "user": {
            "_id": "551a938af056a7fc099879c1",
            "firstName": "Bill",
            "lastName": "Foo",
            "username": "bill_foo",
            "id": "551a938af056a7fc099879c1"
        },
        "__v": 0,
        "sport": [
            {
                "_id": "551e5e01abb74a8423410b88",
                "nazev": "Hockey"
            }
        ],
        "city": "some_city",
        "advert": "some_advert",
        "title": "some_title",
        "created": "2015-04-04T16:25:24.733Z"
    }
]

Edit: the desired output for user 'admin' would be:

[
    {
        "_id": "5520f52e2c0a22541541bde1",
        "region": {
            "_id": "551e6779d8f1afa01bd86529",
            "name": "region_name"
        },
        "user": {
            "_id": "551a938af056a7fc099879c1",
            "firstName": "John",
            "lastName": "Boo",
            "username": "admin",
            "id": "551a938af056a7fc099879c1"
        },
        "__v": 0,
        "sport": [
            {
                "_id": "551e69c6d8f1afa01bd86533",
                "name": "Running"
            }
        ],
        "city": "some_city",
        "advert": "some_advert",
        "title": "I want to run!",
        "created": "2015-04-05T08:41:18.173Z"
}]

javascript json loops arrays

Answer 1

Answer №1

Iterate over the array and extract each element associated with a user whose username is admin:

var result = [];
var nameToSearchFor = 'admin';

for(var index = 0; index < arr.length; index++)
{
    var item = arr[index];
    if(item.user.username === nameToSearchFor)
    {
        result.push(item);
    }
}

Answer 2

Iterate over the array and extract each element associated with a user whose username is admin:

var result = [];
var nameToSearchFor = 'admin';

for(var index = 0; index < arr.length; index++)
{
    var item = arr[index];
    if(item.user.username === nameToSearchFor)
    {
        result.push(item);
    }
}

Answer 3

Answer №2

If you're looking for a solution to your issue, one approach is to locate the index where the username admin exists. In this scenario, it's at index 0 within the provided JSON array. You can retrieve the entire object by referencing the index, as shown below:

var i = 0;
for(; i< json.length; i++){
  if(json[i].user.username === "admin") break;
}

Once you have found the index, you can access the data related to admin like so:

json[i].user.firstName

You can view a live example in this plunk here

UPDATE If you only wish to extract that specific slice into a new array, you can simply use the slice method with the acquired index.

var newArray = json.slice(i, i+1);

Answer 4

If you're looking for a solution to your issue, one approach is to locate the index where the username admin exists. In this scenario, it's at index 0 within the provided JSON array. You can retrieve the entire object by referencing the index, as shown below:

var i = 0;
for(; i< json.length; i++){
  if(json[i].user.username === "admin") break;
}

Once you have found the index, you can access the data related to admin like so:

json[i].user.firstName

You can view a live example in this plunk here

UPDATE If you only wish to extract that specific slice into a new array, you can simply use the slice method with the acquired index.

var newArray = json.slice(i, i+1);

Answer 5

Answer №3

Utilizing an open source tool such as jinqJs allows you to execute SQL-like queries on arrays.

var data = [
    {
        "_id": "5520f52e2c0a22541541bde1",
        "region": {
            "_id": "551e6779d8f1afa01bd86529",
            "name": "region_name"
        },
        "user": {
            "_id": "551a938af056a7fc099879c1",
            "firstName": "John",
            "lastName": "Boo",
            "username": "admin",
            "id": "551a938af056a7fc099879c1"
        },
        "__v": 0,
        "sport": [
            {
                "_id": "551e69c6d8f1afa01bd86533",
                "name": "Running"
            }
        ],
        "city": "some_city",
        "advert": "some_advert",
        "title": "I want to run!",
        "created": "2015-04-05T08:41:18.173Z"
    },
    {
        "_id": "552010740628cab002b3a700",
        "region": {
            "_id": "551e67b6d8f1afa01bd8652f",
            "name": "region_name"
        },
        "user": {
            "_id": "551a938af056a7fc099879c1",
            "firstName": "Bill",
            "lastName": "Foo",
            "username": "bill_foo",
            "id": "551a938af056a7fc099879c1"
        },
        "__v": 0,
        "sport": [
            {
                "_id": "551e5e01abb74a8423410b88",
                "nazev": "Hockey"
            }
        ],
        "city": "some_city",
        "advert": "some_advert",
        "title": "some_title",
        "created": "2015-04-04T16:25:24.733Z"
    }
];

var result = jinqJs()
                .from(data)
                .where(function(row){return row.user.username==='admin';})
                .select();

document.body.innerHTML = '<pre>' + JSON.stringify(result, null, 4) + '</pre><br><br>';

<script src="https://rawgit.com/fordth/jinqJs/master/jinqjs.js"></script>

Answer 6

Utilizing an open source tool such as jinqJs allows you to execute SQL-like queries on arrays.

var data = [
    {
        "_id": "5520f52e2c0a22541541bde1",
        "region": {
            "_id": "551e6779d8f1afa01bd86529",
            "name": "region_name"
        },
        "user": {
            "_id": "551a938af056a7fc099879c1",
            "firstName": "John",
            "lastName": "Boo",
            "username": "admin",
            "id": "551a938af056a7fc099879c1"
        },
        "__v": 0,
        "sport": [
            {
                "_id": "551e69c6d8f1afa01bd86533",
                "name": "Running"
            }
        ],
        "city": "some_city",
        "advert": "some_advert",
        "title": "I want to run!",
        "created": "2015-04-05T08:41:18.173Z"
    },
    {
        "_id": "552010740628cab002b3a700",
        "region": {
            "_id": "551e67b6d8f1afa01bd8652f",
            "name": "region_name"
        },
        "user": {
            "_id": "551a938af056a7fc099879c1",
            "firstName": "Bill",
            "lastName": "Foo",
            "username": "bill_foo",
            "id": "551a938af056a7fc099879c1"
        },
        "__v": 0,
        "sport": [
            {
                "_id": "551e5e01abb74a8423410b88",
                "nazev": "Hockey"
            }
        ],
        "city": "some_city",
        "advert": "some_advert",
        "title": "some_title",
        "created": "2015-04-04T16:25:24.733Z"
    }
];

var result = jinqJs()
                .from(data)
                .where(function(row){return row.user.username==='admin';})
                .select();

document.body.innerHTML = '<pre>' + JSON.stringify(result, null, 4) + '</pre><br><br>';

<script src="https://rawgit.com/fordth/jinqJs/master/jinqjs.js"></script>

Searching for a specific string within a nested array in a JSON object using JavaScript loops

Answer №1

Answer №2

Answer №3

Similar questions

Having trouble displaying an array in React.JS

Dynamic SQL queries are creating a new layer of security

The VueJS dynamic grid view

What is the best way to upload this file in VueJS?

Using C# to simulate a mousewheel event on an IWebElement in Selenium

Using a wildcard (*) to select elements with JQuery

Executing JavaScript code externally on Electron's local server

What is the best way to insert a button at the end of the last row in the first column and also at the

Locate all span elements with a specific class using jQuery and conceal the parent divs further up in

Check out the article on reading file uploads using jQuery or Javascript

AngularJS ng-repeat: displaying a list of filtered outcomes exclusively

What steps do I need to take to connect a chat feature using the QuickBlox SDK within a React

Shift the sideways movement of the triangle symbol

Break down and extract the fully organized variable using a single expression

Instructions for retrieving a key value pair from a logger's response

What could be causing this getJSON call to return undefined?

Ways to ensure that res.redirect is only executed after the completion of the for() loop

Sanity.io's selection of schema field types for efficient and convenient

Conditions must fail for window.location to execute

Using the JSon structure to call upon a RESTful API