Aggregate results in table

Ask the community
,
1

Hey guys:

I create an aggregation from a database and I want to show results in a table. This is de code:

export function button15_click(event) {

wixData.aggregate("HistoriaClinica")
  .group("ciudad")
  .count()
  .run()
  .then( (results) => {
 let items = results.items;
    $w("#table1").rows = items;
    console.log(items)

    $w("#table1").columns = [
      {
 "id": "col1",
 "dataPath": "ciudad",
 "label": "Ciudad",
 "type": "string",
      },
     ];

  });

}

And this is the result in the table:

Question is: ¿How can I show the count results in the second column?

Thanks!!

2

Ok, so it worked with a table (nice to know) :grin:.
Do not forget to connect your post with your privious one, so others can also learn from it :wink:.

https://www.wix.com/velo/forum/community-discussion/display-aggregate-in-a-repeater

3

But I dont kwon how to show the count results!

This is what It shows the console:


_id: 
"CIMITARRA SANTANDER"
count: 
6
ciudad: 
"CIMITARRA SANTANDER"

I need to show in one column the count

4

???

$w("#table1").columns = [
    {
 "id": "col1",
 "dataPath": "ciudad",
 "label": "Ciudad",
 "type": "string",
    },

    {
 "id": "col2",
 "dataPath": "count",
 "label": "Counts",
 "type": "string", //number?
    },

    {
 "id": "col3",
 "dataPath": "_id",
 "label": "Index",
 "type": "string", //number?
    },
];
5

@russian-dima YOU ROCK!!! IT FINALLY WORKS!!!

6

@danieltalero78 :wink: (now it’s really time to go to bed xD).

Good luck with your project and happy coding.