Aggregate with meteor? (aggregate is not a function)

[robfallows]

Is category an index? (category will get more info from evenscats -> image, name and more)

I think you misunderstood what I was asking. If you’re doing a find({category:'running'}) you should ensure the category field in your Events collection is indexed, or you’ll get potentially crippling performance issues - especially with 100000+ documents. That will also affect any publications you may do like that.

[thorus]

Perfekt, but now I have trouble with getting the data names from the getyears function:

I’m trying to get at v-select to work with some data, but I only get object,object https://codepen.io/nordthorus/pen/zXyewY (the getyears works, its just the v-selcted that dont)
I can se the data with: Selected: {{ selected }} when i click the only dropdown with object,object (it like I need to use a v-for with options)

Selected: { “2018”: 1, “2019”: 1 }

[robfallows]

I haven’t used Vue and don’t really understand what may be happening, so I can’t offer any immediate help. Perhaps the result from getyears is not in the right format for Vue?

[thorus]

It worked with:

   <select v-model="selected">
     <option v-for='(value, key) in getyears' :value='key' >{{key}} - {{value}} gang(e)</option>
      
    </select>

[thorus]

function getyears

Hi again,

Howto sendt a (categoryId variable to function getyears?

category: ‘running’ -> running have to be the categoryId from the list i’m looping.

Birthday: id: 1
Running: id: 2
Mtb: id:3

[robfallows]

I don’t understand what you’re asking.

[thorus]

Sorry, I will try again

Have to find Events where category is the same as a variable that comes from: (VARIABLE = thecat.name)

<v-card v-if="catId == thecat.name"  v-for="thecat in getcats" :key="thecat._id">
<span class="grey-light pt-3 mt-3">
   <select v-model="thisYear">
     <option v-for='(value, key) in getyears' :value='key'>{{key}} - {{value}} gang(e)</option>
      
    </select>
</span>
</v-card>

So howto send a VARIABLE to: Mtb = VARIABLE = thecat.name

export default {
  meteor: {
  getyears: () {
  return Events.find({ category: VARIABLE })
    .fetch()
    .map(doc => doc.thedate.substr(0, 4))
    .reduce((years, year) => {
    if (year in years) {
      years[year]++;
    } else {
      years[year] = 1;
    }
    return years;

  }, {});
}

[robfallows]

Unless I still don’t understand:

<option v-for='(value, key) in getyears(thecat)' :value='key'>{{key}} - {{value}} gang(e)</option>

and

export default {
  meteor: {
  getyears(category) {
  return Events.find({ category })
    .fetch()
    .map(doc => doc.thedate.substr(0, 4))
    .reduce((years, year) => {
    if (year in years) {
      years[year]++;
    } else {
      years[year] = 1;
    }
    return years;

  }, {});
}

[thorus]

(thecat)

I get this: [Vue warn]: Error in render: “TypeError: _vm.getyears is not a function”

[thorus]

Is it becasue I use in:

export default {
  meteor: {

so it can not take variables?

Normally I can do waht you wtrite but not in
export default {
meteor: {

[robfallows]

Well, as I said earlier, I haven’t used Vue. So, using my approach of “I don’t know what I’m doing, so try this”, you could try this:

<option v-for='(value, key) in meteor.getyears(thecat)' :value='key'>{{key}} - {{value}} gang(e)</option>

[thorus]

I get this: [Vue warn]: Error in render: “TypeError: _vm.getyears is not a function”

Get thsi error: getyears undefiend

Is it possible to insert the code other places then i

export default {
  meteor: {

[robfallows]

I’m just not familiar enough with Vue or your code to suggest anything else. Sorry.

[thorus]

I’m missing some coding knowledge so its hard to se how it works.

but can you se howto use this filter with the code you made?
https://codepen.io/nordthorus/pen/mggNgZ

instead of:

• 2019-04-25
• 2019-04-25
• 2018-04-25
• 2019-04-25

it must write:
2019 3 time
2018 1 time

Hope you can help, its the last thing before I can release a beta of a meteor app

[thorus]

getyears(category)

Now it works:

<span class="grey-light pt-3 mt-3">
   <select v-model="thisYear">
     <option v-for='(value, key) in getyears(thecat.name)' :value='key'>{{key}} - {{value}} gang(e)</option>
      
    </select>
</span>

It worked when i moved it to methods outside data

methods: {
      getyears(category) {
  return Events.find({category: category})
    .fetch()
    .map(doc => doc.thedate.substr(0, 4))
    .reduce((years, year) => {
    if (year in years) {
      years[year]++;
    } else {
      years[year] = 1;
    }
    return years;
  }, {});
},

Big thanks for your help robfallows

[thorus]

2019 3 time

One last thing, how to SORT so newest year comes first?

2019 3 time
2018 1 time

and not like now:

2018 1 time
2019 3 time

[robfallows]

You could add a descending sort into the chain. As the (string) year can be represented as a number, this should work:

  getyears(category) {
    return Events.find({ category: category })
      .fetch()
      .map(doc => doc.thedate.substr(0, 4))
      .sort((a,b) => ~~b - ~~a )
      .reduce((years, year) => {
        if (year in years) {
          years[year]++;
        } else {
          years[year] = 1;
        }
        return years;
      }, {});
  },

[thorus]

I still get the oldest year first,

I can se that sort works here: https://www.w3schools.com/js/tryit.asp?filename=tryjs_array_sort3

[robfallows]

Ah, yes. Unfortunately, Node ensures that object keys which appear to be numeric are stored/retrieved in ascending order, which I’d forgotten. The solution becomes a little more complex:

getyears(category) {
  const result = Events.find({ category })
    .fetch()
    .map(doc => doc.thedate.substr(0, 4))
    .reduce((years, year) => {
      if (year in years) {
        years[year]++;
      } else {
        years[year] = 1;
      }
      return years;
    }, {});
  return Object.keys(result).sort((a, b) => ~~b - ~~a)
    .map(year => ({ year, count: result[year] }));
}

The result is now an array of objects, such as:

[
  {
    "year": "2019",
    "count": 1
  },
  {
    "year": "2018",
    "count": 5
  },
  {
    "year": "2011",
    "count": 3
  }
]

Which means you will need to alter your presentation code accordingly.

Alternatively, you could use the original code, but ensure the year is prefixed with a space, which is sufficient to ensure that the order is preserved. The map would then look like:

.map(doc => ` ${doc.thedate.substr(0, 4)}`)

and you can continue to use your current presentation code.

[znewsham]

I’ve never thought to use reduce like this, that’s awesome