Counting elements in database collection

Ask the community
,
1

How does one count occurrences in a collection in the database?

One of the columns in a collection in the database is numbers. I wish to count the occurrence of a specific number in the column. This is the code i the back end sow far:

import wixData from 'wix-data';

export function Counter(Number1) {
wixData.query("TestData")
  .eq("PostalCode", Number1)
  .count()
  .then( (num) => {
 let numberOfItems = num;
 return numberOfItems;
  } )
  .catch( (error) => {
 let errorMsg = error.message;
 let code = error.code;
  } );
}

In the above I would think the numberOfItems would contain the number of items. The front end looks like this:


import {Counter} from 'backend/Counter';

$w.onReady(function () {
 
    Counter(2100)
    .then(numberOfItems => {
        console.log(numberOfItems);
    })
    .catch(error => {
        console.log(error);
    });
});

In the console it displays undefined, which means that numberOfItems is undefined which is weird because the function returns numberOfItems. What’s wrong?

Thanks
Erik

2

Is there a specific reason you are performing a count function on the backend without the need to suppress hooks or permission checks? You can do it on the frontend too.

However you can do it from the backend like this:

First, you need to make sure that the Database Field PostalCode is a Number field and not text.

Second put a return to the start of your query like this

return wixData.query("TestData")
3

The reason why I want to do it the in the back end is because I would like the change to add suppressions of hooks and other additions only accessibly in the backend.

However, it’s not counting… The backend code looks like this (as expected):

import wixData from 'wix-data';

export function Counter(Number1) {
return wixData.query("TestData")
  .eq("PostalCode", Number1)
  .count()
  .then( (num) => {
 let numberOfItems = num;
 return numberOfItems;
  } )
  .catch( (error) => {
 let errorMsg = error.message;
 let code = error.code;
  } );
}

The Database field PostalCode is a number field.

import {Counter} from 'backend/Counter';

$w.onReady(function () {
 
    Counter(1800)
    .then(numberOfItems => {
        console.log(numberOfItems);
    })
    .catch(error => {
        console.log(error);
    });
});

I know that the number1800 is represented in the database field but the output is given as 0. Any idear why this is?

4

@erik screenshot your PostalCode database field please

5

@shantanukumar847 yes!
Btw all the info is just random info I generated.

1243×584 20 KB

6

I found the mistake!! The keyword for the PostalCode field is postalCode not PostalCode…
Man I feel stupid!!
It works now, thank you shan!!

7

Hi,

My requirement is pretty simple, I have been trying to count the number of fields in a dataset collection and display the results in a textbook. No matter however I try with various iterations , the textbook displays 0.

This is my code:

wixData.query(“TransportDatabase”)
.eq(“title”, true )
.count()
.then( (num) => {
let numberOfItems = num;
$w(‘#text2’).text=numberOfItems;
} )
. catch ( (error) => {
let errorMsg = error.message;
let code = error.code;
} );

Kindly advise me on this , am done with the rest of website and have been stuck with this for quite some time.

8

Erik,
Did you ever get this to work?