Sohaib Mustafa
Sohaib Mustafa

Reputation: 99

trying to filter array of objects with array in itself

I filtering group of object like this:

[
{
  "Username":"00d9a7f4-0f0b-448b-91fc-fa5aef314d06",
  "Attributes":[
     {
        "Name":"custom:organization",
        "Value":"zxc"
     },
     {
        "Name":"sub",
        "Value":"00d9a7f4-0f0b-448b-91fc-fa5aef314d06"
     },
     {
        "Name":"email_verified",
        "Value":"false"
     },
     {
        "Name":"email",
        "Value":"[email protected]"
     }
  ],
  "UserCreateDate":"2021-02-04T17:59:28.212Z",
  "UserLastModifiedDate":"2021-02-04T17:59:28.212Z",
  "Enabled":true,
  "UserStatus":"UNCONFIRMED"
},
{
  "Username":"07c16a30-b994-4267-9794-6fb20739abeb",
  "Attributes":[
     {
        "Name":"custom:organization",
        "Value":"asd"
     },
     {
        "Name":"sub",
        "Value":"07c16a30-b994-4267-9794-6fb20739abeb"
     },
     {
        "Name":"email_verified",
        "Value":"false"
     },
     {
        "Name":"email",
        "Value":"[email protected]"
     }
  ],
  "UserCreateDate":"2021-02-04T17:56:13.787Z",
  "UserLastModifiedDate":"2021-02-04T17:56:13.787Z",
  "Enabled":true,
  "UserStatus":"UNCONFIRMED"
},

Following is filtering fine

let filterarry;
filterarry = jsonObject.filter(Attributes => {
  return Attributes.Enabled == true && Attributes.UserStatus == 'UNCONFIRMED';
});
console.log(filterarry);

I am trying to filter by Attributes having: Attributes that have custom:organization and with value zxc how can I do that ??

"Attributes":[
 {
    "Name":"custom:organization",
    "Value":"zxc"
 },

I tried few methods but i am getting empty array in output Thanks

Upvotes: 0

Views: 58

Answers (3)

D. Seah
D. Seah

Reputation: 4592

you can try this

const oObjects = [{
    "Username": "00d9a7f4-0f0b-448b-91fc-fa5aef314d06",
    "Attributes": [{
        "Name": "custom:organization",
        "Value": "zxc"
      },
      {
        "Name": "sub",
        "Value": "00d9a7f4-0f0b-448b-91fc-fa5aef314d06"
      },
      {
        "Name": "email_verified",
        "Value": "false"
      },
      {
        "Name": "email",
        "Value": "[email protected]"
      }
    ],
    "UserCreateDate": "2021-02-04T17:59:28.212Z",
    "UserLastModifiedDate": "2021-02-04T17:59:28.212Z",
    "Enabled": true,
    "UserStatus": "UNCONFIRMED"
  },
  {
    "Username": "07c16a30-b994-4267-9794-6fb20739abeb",
    "Attributes": [{
        "Name": "custom:organization",
        "Value": "asd"
      },
      {
        "Name": "sub",
        "Value": "07c16a30-b994-4267-9794-6fb20739abeb"
      },
      {
        "Name": "email_verified",
        "Value": "false"
      },
      {
        "Name": "email",
        "Value": "[email protected]"
      }
    ],
    "UserCreateDate": "2021-02-04T17:56:13.787Z",
    "UserLastModifiedDate": "2021-02-04T17:56:13.787Z",
    "Enabled": true,
    "UserStatus": "UNCONFIRMED"
  },
];


const filterarry = oObjects.filter(attr => {
  return attr.Enabled &&
    attr.UserStatus === 'UNCONFIRMED' &&
    attr.Attributes.some(p => p.Name === "custom:organization" && p.Value === "zxc");
});
console.log(filterarry);

Upvotes: 0

0xLogN
0xLogN

Reputation: 3823

You can do this:

let output = jsonObject.filter(entry => {
    // filter the internal array and check
    if (entry.Attributes.filter(attr => attr.Name === 'custom:organization' && attr.Value === 'zxc').length !== 0) {
        return true;
    }
    return false;
});

See also: https://stackoverflow.com/a/8217584/14133230

Upvotes: 1

uingtea
uingtea

Reputation: 6554

To filter jsonObject.Attributes you need to recreate and the variable

let filterarry = jsonObject.filter(item => {
  item.Attributes = item.Attributes.filter(attr => {
    return attr.Name == "custom:organization" && attr.Value == "zxc"
  })

  // return true => to remove only value of jsonObject.Attributes but not the parent
  return item.Attributes.length;
});

results

[
  {
    "Username": "00d9a7f4-0f0b-448b-91fc-fa5aef314d06",
    "Attributes": [
      {
        "Name": "custom:organization",
        "Value": "zxc"
      }
    ],
    "UserCreateDate": "2021-02-04T17:59:28.212Z",
    "UserLastModifiedDate": "2021-02-04T17:59:28.212Z",
    "Enabled": true,
    "UserStatus": "UNCONFIRMED"
  }
]

Upvotes: 0

Related Questions