group and array of object data javascript

Question

So i have an array of object from mongodb query like below,its contained the value from $agg:

[
  {
    "_id": "17000691",
    "latestAnswer": [
      {
        "title": "Test",
        "date": "2022-11-16",
        "position": "Foreman",
        "department": "Production",
        "username": "17000691"
      }
    ]
  },
  {
    "_id": "MT220047",
    "latestAnswer": [
      {
        "title": "Test",
        "date": "2022-11-15",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      },
      {
        "title": "Test",
        "date": "2022-11-16",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      },
      {
        "title": "Test",
        "date": "2022-11-16",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      },
      {
        "title": "Untitled Form1",
        "date": "2022-11-16",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      }
    ]
  }
]

is there a possible way to group the data base on date, title and username into this?

[
  {
    "username": "MT220047",
    "title": "Test",
    "position": "Management Trainee",
    "department": "Logistic",
    "2022-11-15": 1,
    "2022-11-16": 2
  },
  {
    "username": MT220047,
    "title": UntitledForm1,
    "position": "Management Trainee",
    "department": "Logistic",
    "2022-11-16": 1
  },
  {
    "username": 17000691,
    "title": Test,
    "position": "Foreman",
    "department": "Production",
    "2022-11-16": 1,
    
  }
]

any help on this will be useful for mee... thanks.., it try to mapping it but seems little confused bout the logic to group it as i want

Can you show us the code, which you used to try to map it?

Geshode
– Geshode

2022-11-16 08:16:18 +00:00
Commented Nov 16, 2022 at 8:16 — Geshode
– Geshode, Commented Nov 16, 2022 at 8:16
okay waitt will provide it on the questrion

JS24
– JS24

2022-11-16 08:17:17 +00:00
Commented Nov 16, 2022 at 8:17 — JS24
– JS24, Commented Nov 16, 2022 at 8:17

Pierfrancesco · Accepted Answer · 2022-11-16 08:46:32Z

1

Something like this could work?

const payload = [
  {
    "_id": "17000691",
    "latestAnswer": [
      {
        "title": "Test",
        "date": "2022-11-16",
        "position": "Foreman",
        "department": "Production",
        "username": "17000691"
      }
    ]
  },
  {
    "_id": "MT220047",
    "latestAnswer": [
      {
        "title": "Test",
        "date": "2022-11-15",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      },
      {
        "title": "Test",
        "date": "2022-11-16",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      },
      {
        "title": "Test",
        "date": "2022-11-16",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      },
      {
        "title": "Untitled Form1",
        "date": "2022-11-16",
        "position": "Management Trainee",
        "department": "Logistic",
        "username": "MT220047"
      }
    ]
  }
]

const accumulator = {};
const final = []
const res = payload
.map((payload) => payload.latestAnswer)
.reduce((acc, curr) => { acc.push(...curr); return acc}, []);
res.forEach((item) => {
  const {username, title, position, department, date} = item
  const key = `${username}-${department}-${position}-${title}`
  accumulator[key] =  accumulator[key] || {};
  accumulator[key][date] = accumulator[key][date] + 1 || 1
})

Object.keys(accumulator).forEach((item) => {
  const [username, department, position, title] = item.split('-')
  final.push({
    username, 
    department, 
    position, 
    title,
    ...accumulator[item]
  })
})

For sure can be improved but you should get the spirit of the algo.

edited Nov 16, 2022 at 8:46

answered Nov 16, 2022 at 8:29

Pierfrancesco

5186 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JS24 Over a year ago

can we group it again into result i mentioned above?

Pierfrancesco Over a year ago

I've updated the answer, please take a look.

Collectives™ on Stack Overflow

group and array of object data javascript

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related