Load a repeater from 2 datasets

Ask the community
,
1

This is my first code, please could someone help me?

I need to query one Collection (Orcamentos) than load the result into a repeater (#ListaPalmeiras), getting data from 2 datasets (#dataset1 and #dataset3).

#dataset1 - based on the Collection ‘Lista_de_Palmeiras’;
#dataset3 - based on the Colection ‘Orcamentos’;
orcamentos.palmeira_id is referenced to Lista_de_Palmeiras_id;

The repeater #ListaPalmeiras has:
#imagem → #dataset1.imagem
#nomecientifico → #dataset1.title
#nomepopular → #dataset1.nomePopular
#tronco → #dataset3.tronco;
#altura → #dataset3.altura
#qtd → #dataset3.qtd;

When I load the page, the fields #imagem, #nomecientifico and #nomepopular are correct, but the others are showing the same data, from the first line.

1522×452 103 KB

The code is:

// For full API documentation, including code examples, visit Velo API Reference - Wix.com
import wixData from ‘wix-data’;
import wixUsers from ‘wix-users’;
import wixLocation from ‘wix-location’;

$w.onReady( async function () {
// Get the current user.
let user = wixUsers.currentUser;
if (user.loggedIn)
return loadPalmeiraOrcadaLista();

      $w('#ListaPalmeiras').collapse(); 
      $w('#Orcamentovazio').expand();

});

// Load and display the current user’s wishlist.
async function loadPalmeiraOrcadaLista (){
// Get the current user.
let user = wixUsers.currentUser;
let orcamentolistResult = await wixData.query(“Orcamentos”)
.eq(“user_id”, user.id)
.eq(“status”, “Em Andamento”)
.eq(“tipo_linha”, “Palmeira”)
.include(‘palmeira_id’)
.find()
// If any wishlist items were found:
if (orcamentolistResult.length > 0) {
$w(“#ListaPalmeiras”).expand();
$w(“#Orcamentovazio”).collapse();
// Set the wishlist repeater’s data.
$w(“#ListaPalmeiras”).data = orcamentolistResult.items;
$w(‘#ListaPalmeiras’).onItemReady(myItemReady);
}
// If no wishlist items were found:
else {
$w(“#ListaPalmeiras”).collapse();
$w(“#Orcamentovazio”).expand()
}
}

// Set up the wishlist repeater items when the repeater’s data is loaded.
function myItemReady($w, palmeiraorcadaItem){
// Get the wishlist product
let orcamento = palmeiraorcadaItem;
let palmeira = palmeiraorcadaItem.palmeira_id;
// Set the repeater’s elements using the item data.
$w(‘#altura’).text = orcamento.altura; — is incorrect
$w(‘#qtd’).text = orcamento.qtd; — is incorrect
$w(‘#tronco’).text = orcamento.tronco; — is incorrect
$w(‘#imagem’).src = palmeira.imagem; — is correct
$w(‘#nomecientifico’).text = palmeira.title; — is corect
$w(‘#nomepopular’).text = palmeira.nomePopular; — is correct
}

What am I missing?

Camila