Filter an array of objects recursively based on various properties

Question

Filter an array of objects recursively based on various properties

I need help filtering an object with nested arrays based on specific criteria. Specifically, I want to filter the main array by matching either RazaoSocial:"AAS" or Produtos:[{Descricao:"AAS"}]

This is my code:

var input = [
  {
    RazaoSocial: 'AAS',
    Produtos: [
    { DescricaoProduto: 'XXX', id:12, other:"other text" },
      { DescricaoProduto: 'YYY', id:12, other:"other text" }
    ]
  },
  {
    RazaoSocial: 'I found you',
    Produtos: [
      { DescricaoProduto: 'AAS', id:12, other:"other text" },
      { DescricaoProduto: 'Miss8', id:12, other:"other text" },
      { DescricaoProduto: 'Miss8', id:12, other:"other text" },
      { DescricaoProduto: 'Miss8', id:99, other:"other text" }      
    ]
  },
  {
    RazaoSocial: 'bla',
    Produtos: [
        { DescricaoProduto: 'AB', id:12, other:"other text" },
        { DescricaoProduto: 'CD', id:12, other:"other text" },
    ]
  },  
];

var res = input.filter(function f(o) {
    if (o.RazaoSocial.includes("AAS")) return true
    if (o.Produtos.DescricaoProduto) {
        console.log(o.Produtos);
        return (o.Produtos = o.Produtos.filter(f)).length
    }
})
 console.log(JSON.stringify(res, null, 2));

//result

[
  {
    "RazaoSocial": "AAS",
    "Produtos": [
      {
        "DescricaoProduto": "XXX",
        "id": 12,
        "other": "other text"
      },
      {
        "DescricaoProduto": "YYYAAS",
        "id": 12,
        "other": "other text"
      }
    ]
  }
]

I'm wondering why the object with RazaoSocial "I found you" is not returned in the result even though it meets the criteria.

[
        {
            RazaoSocial: 'AAS',
            Produtos: [
                { DescricaoProduto: 'XXX', id: 12, other: "other text" },
                { DescricaoProduto: 'YYY', id: 12, other: "other text" }
            ]
        },
        {
            RazaoSocial: 'I found you',
            Produtos: [
                { DescricaoProduto: 'AAS', id: 12, other: "other text" },
                { DescricaoProduto: 'Miss8', id: 12, other: "other text" },
                { DescricaoProduto: 'Miss8', id: 12, other: "other text" },
                { DescricaoProduto: 'Miss8', id: 99, other: "other text" }
            ]
        }
    ]

I have tried various examples without success. Can someone please point out where I might be going wrong?

Thank you for your assistance.

javascript arrays recursion filter

Answer 1

Answer №1

The primary issue in the initial attempt was the usage of if (o.Products.Description)

o.Products is an array, so accessing o.Products.Description directly requires specifying an index first.

Since o.Products is an array, it needs to be filtered similar to the original input.

I've included both a recursive and non-recursive method for comparison.

The recursive solution is versatile and can locate any desired value.

var input = [
  {
    Name: 'AAS',
    Products: [
      { Description: 'XXX', id:12, other:"other text" },
      { Description: 'YYY', id:12, other:"other text" }
    ]
  },
  {
    Name: 'I found you',
    Products: [
      { Description: 'AAS', id:12, other:"other text" },
      { Description: 'Miss8', id:12, other:"other text" },
      { Description: 'Miss8', id:12, other:"other text" },
      { Description: 'Miss8', id:99, other:"other text" }      
    ]
  },
  {
    Name: 'bla',
    Products: [
        { Description: 'AB', id:12, other:"other text" },
        { Description: 'CD', id:12, other:"other text" },
    ]
  },  
];

var useRecursive = true, 
    res;
if (useRecursive) {
  var findValue = function (str) {
      return function(o) {
          return Object.values(o).filter(function (value) {
              if (Array.isArray(value)) {
                  return value.filter(findValue(str)).length > 0
              } else {
                  return value.toString().includes(str)
              }
          }).length > 0;
      };
  };
  res = input.filter(findValue("AAS"))

} else {
  res = input.filter(function f(o) {
    if (o.Name.includes("AAS")) return true
    if (o.Products.length) {
        return o.Products.filter(function(o1) {
          return o1.Description.includes("AAS");
        }).length;
    }
  })
}
console.log(JSON.stringify(res, null, 2));

Answer 2

The primary issue in the initial attempt was the usage of if (o.Products.Description)

o.Products is an array, so accessing o.Products.Description directly requires specifying an index first.

Since o.Products is an array, it needs to be filtered similar to the original input.

I've included both a recursive and non-recursive method for comparison.

The recursive solution is versatile and can locate any desired value.

var input = [
  {
    Name: 'AAS',
    Products: [
      { Description: 'XXX', id:12, other:"other text" },
      { Description: 'YYY', id:12, other:"other text" }
    ]
  },
  {
    Name: 'I found you',
    Products: [
      { Description: 'AAS', id:12, other:"other text" },
      { Description: 'Miss8', id:12, other:"other text" },
      { Description: 'Miss8', id:12, other:"other text" },
      { Description: 'Miss8', id:99, other:"other text" }      
    ]
  },
  {
    Name: 'bla',
    Products: [
        { Description: 'AB', id:12, other:"other text" },
        { Description: 'CD', id:12, other:"other text" },
    ]
  },  
];

var useRecursive = true, 
    res;
if (useRecursive) {
  var findValue = function (str) {
      return function(o) {
          return Object.values(o).filter(function (value) {
              if (Array.isArray(value)) {
                  return value.filter(findValue(str)).length > 0
              } else {
                  return value.toString().includes(str)
              }
          }).length > 0;
      };
  };
  res = input.filter(findValue("AAS"))

} else {
  res = input.filter(function f(o) {
    if (o.Name.includes("AAS")) return true
    if (o.Products.length) {
        return o.Products.filter(function(o1) {
          return o1.Description.includes("AAS");
        }).length;
    }
  })
}
console.log(JSON.stringify(res, null, 2));

Answer 3

Answer №2

let result = data.map(function filterFunction(obj) {
    let returnValue = false;
    if (obj.Name.includes("XYZ")) returnValue  = true
    if (obj.Items.Description) {
        console.log(obj.Items);
        returnValue  = (obj.Items = obj.Items.filter(filterFunction)).length
    }
    return returnValue; 
})

I have not tested this code yet, so please use it cautiously

Answer 4

let result = data.map(function filterFunction(obj) {
    let returnValue = false;
    if (obj.Name.includes("XYZ")) returnValue  = true
    if (obj.Items.Description) {
        console.log(obj.Items);
        returnValue  = (obj.Items = obj.Items.filter(filterFunction)).length
    }
    return returnValue; 
})

I have not tested this code yet, so please use it cautiously

Answer 5

Answer №3

Instead of using recursion, you can achieve the desired result by implementing a simple filter like the one below:

var filteredObjects = input.filter(function (object) {
 return object.RazaoSocial.includes("AAS") ||
   object.Products && object.Products.find(function (product) {
     return product.ProductDescription === 'AAS';
 }));
console.log(JSON.stringify(filteredObjects, null, 2));

This code snippet will give you an array containing objects with RazaoSocial matching 'AAS' or Products with ProductDescription equal to 'AAS'.

Answer 6

Instead of using recursion, you can achieve the desired result by implementing a simple filter like the one below:

var filteredObjects = input.filter(function (object) {
 return object.RazaoSocial.includes("AAS") ||
   object.Products && object.Products.find(function (product) {
     return product.ProductDescription === 'AAS';
 }));
console.log(JSON.stringify(filteredObjects, null, 2));

This code snippet will give you an array containing objects with RazaoSocial matching 'AAS' or Products with ProductDescription equal to 'AAS'.

Filter an array of objects recursively based on various properties

Answer №1

Answer №2

Answer №3

Similar questions

incorporating theme.spacing in the declaration of the theme

Managing file sizes on the client side prior to transferring them to the server side

How can I retrieve the PHP response once a successful upload has occurred using DropzoneJS?

Error occurred when attempting to fetch data from a nested JSON object in React/Next.JS

What is the best way to adjust the placement of a component to remain in sync with the v-model it is connected to?

Can JQuery be used to identify the CSS styles applied to selected elements?

Ways to convert a JavaScript object's properties into JSON format

What discrepancies exist between running npm install on Windows versus Linux operating systems?

Arranging a nested JSON array directly

Troubleshooting Problem with Creating a Button using HTML Checkbox "onclick" Event

Tips for linking weight scale device to a website

Analyzing JSON parsing efficiency

Having trouble with updating label text in MUIDataTable in ReactJS?

Unable to access filteredItems from custom popup in uib-typeahead retrieval process

Triggering a form submission in JavaScript when a selection is changed

Utilize Fb.api to automatically post on user's wall upon logging in

Values in Vuex do not get updated by getters

I encounter difficulty utilizing assets within my React application

Using NodeJS, pull JSON data from a JavaScript file and render it in a route file

Discovering the number of intervals running at any given time within the console - JavaScript