I have been trying to get the total count of a value in a field ‘pnumber’ accessed through the first filtered query ,My code seems not to work.
import wixData from 'wix-data';
import wixUsers from 'wix-users';
let user = wixUsers.currentUser;
let userId = user.id;
let isLoggedIn = user.loggedIn;
user.getEmail()
.then( (email) => {
let userEmail = email;
} );
$w.onReady(() => {
Sum_amount();
});
let filter = wixData.filter().eq("_owner",userId)
export function Sum_amount(){
wixData.aggregate("Referrals")
.group("_owner")
.filter(filter)
.sum("pnumber","sumHours")
.run()
.then( (results) => {
let sumHrs = Number(results.items[0].sumHours)
wixData.query("Referrals")
.eq("referral", sumHrs)
.find()
.then( (results) => {
if(results.items.length > 0) {
let items = results.items;
let firstItem = items[0];
let totalCount = results.totalCount;
let pageSize = results.pageSize;
let currentPage = results.currentPage;
let totalPages = results.totalPages;
let hasNext = results.hasNext();
let hasPrev = results.hasPrev();
let length = results.length;
let query = results.query;
$w("#text33").text = totalCount.toString();
} else {
$w("#text33").text="no referrals yet!"
// handle case where no matching items found
}
} )
.catch( (error) => {
let errorMsg = error.message;
let code = error.code;
} )}}
Anyone with an idea of where i have made a mistake?