First :
If you look at that page, results start with 99.xx. (https://tinetine11.wixsite.com/website/principalcompetitif3/Junior-Dames)
Then if you go down, there are score in the 100 that should be at the top.
So the .descending not working properly.
Second :
If you click on the first skater of this link (https://tinetine11.wixsite.com/website/principalcompetitif2/Junior-Dames)
you can see that her best score is over 100 that should be there. So the .MAX is not working properly.
Conclusion :
Something is going wrong with data over 100 points. I realised that some score was not correctly done with under 100, but seems to be temporary as now it is working. But over 100, seems to be always in error.
Please help!
This is the code of the page :
// For full API documentation, including code examples, visit Velo API Reference - Wix.com
import wixLocation from ‘wix-location’;
import wixData from ‘wix-data’
$w.onReady( function () {
let donCategorie = $w(‘#dynamicDataset’).getCurrentItem()
let filter = wixData.filter().eq(“categorie”, donCategorie.categorie);
$w('#text7').text = donCategorie.categorie
wixData.aggregate("principalcompetitif2")
.filter(filter)
.group("prenom", "nom", "cpa")
.max("free")
.descending("freeMax")
.limit(1000)
.run()
.then(res => {
//console.log(res.items);
//$w(‘#table2’).rows = res.items;
$w(‘#table2’).rows = res.items.map((item, index) => Object.assign({}, item, { Rang: index + 1 }));
});
//console.log(donCategorie.categorie);
$w(“#table2”).onRowSelect((event) => {
let rowData = event.rowData;
//console.log(rowData);
let selNom = rowData.nom;
let selPrenom = rowData.prenom;
let selCPA = rowData.cpa;
wixLocation.to(“/principalcompetitif2/” + selPrenom + “/” + selNom + “/” + selCPA);
});
});