bjar
August 18, 2020, 5:17pm
1
I use the following code to feed a repeater with the data of “Events” and “Companies” :
in table “Events”, the field “compagnie” is a reference of table “Compagnies” with primary field “title”
My code is :
import wixData from ‘wix-data’ ;
$w.onReady( function () {
async function buildFiltersAndPopulateRepeater() {// EvenementListe is my repeater name #EvenementListe ’ ).data = await dataQuery.find().then((res) => res.items);
function initRepeater() {#EvenementListe ’ ).onItemReady(($item, itemData) => {// pDate, pHeure, pLieu, pTitre… are text and buton elements in repeater // this code works correctly #pDate ’ ).text = itemData.dateAffiche;#pHeure ’ ).text = itemData.heureAffiche;#pLieu ’ ).label = itemData.salleAffiche;#pTitre ’ ).text = itemData.title;#pSousTitre ’ ).text = itemData.infoSpcialeSoustitre;#pChoregraphe ’ ).text = itemData.chorgraphe;#pDetail ’ ).text = itemData.dtail;// this code that doesn’t work : syntax ? #pCompagnie ’ ).label = itemData.Compagnies.title ;
Can you help me ?
bjar
August 18, 2020, 5:36pm
3
Thanks, but I have no problem with the filter, nor with the sort, but only with the syntax to use to read the data from the include table.
bjar
August 18, 2020, 5:47pm
4
oups, there is an error in the code above: you should read this:
let dataQuery = wixData.query( ‘Events’ ).include( ‘Compagnies’ );#EvenementListe ’ ).data = await dataQuery.find().then((res) => res.items);
where #EvenementListe is a repeater
the result is : if i use $item( ’ #pCompagnie ’ ).label = itemData.compagnie
I do not know the structure of your collections (" Events" , and “Compagnies” ).
Sorry, i think i am not really able to help you.
bjar
August 18, 2020, 6:45pm
6
Hello,
It would be better to know the all the name_ids of reference-fields in “Compagnies”.
For which COLUMN are you searching for in your “Compagnies”-DATABASE ?
You are refering here to title.
// it's the code that doesn't work : syntax itemData.compagnies.title is wrong $item('#pCompagnie').label = itemData.Compagnies.title ;
Show on a pic the column you need. Is is really “title”, what you are searching for?
bjar
August 18, 2020, 7:05pm
8
@russian-dima
@bjar
Ok sorry, at the moment without any idea. Perhaps it is already a little bit to late to overload my little brain
@bjar
import wixData from 'wix-data';
import { debounce } from 'lodash';
$w.onReady(function () {
initComps();
initRepeater();
buildFiltersAndPopulateRepeater();
});
async function initComps() {
// populate iSalle dropdown
const res = await wixData.query('Events')
.ascending('salleAffiche')
.distinct('salleAffiche')
.then((locationData) => {
return locationData.items.map((location) => {
return {
value: location,
label: location
}
});
});
$w('#iSalle').options = res;
// bind all input elements
const componentsTypeArray = ['RadioButtonGroup', 'Dropdown'];
const debounceFunction = debounce(buildFiltersAndPopulateRepeater, 200);
componentsTypeArray.forEach((compType) => {
const compArray = $w(compType);
compArray.forEach((comp) => {
comp.onChange((event) => {
debounceFunction();
});
});
});
}
async function buildFiltersAndPopulateRepeater() {
let dataQuery = wixData.query('Events').include('Compagnies');
if ($w('#iSalle').value) {
dataQuery = dataQuery.eq('salleAffiche', $w('#iSalle').value);
}
// dataQuery = dataQuery.ascending("date") ;
if ($w('#iTri').value) {
dataQuery = dataQuery.ascending($w('#iTri').value) ;
}
$w('#InfoPreparation').show() ;
$w('#ImageSablier').show() ;
$w("#EvenementListe").hide();
$w('#EvenementListe').data = await dataQuery.include('Compagnies').find().then((res) => res.items);
$w('#InfoPreparation').hide() ;
$w('#ImageSablier').hide() ;
$w("#EvenementListe").show();
}
function initRepeater() {
$w('#EvenementListe').onItemReady(($item, itemData) => {
//$item('#pImage').src = itemData.thumbnailImage;
$item('#pDate').text = itemData.dateAffiche;
$item('#pHeure').text = itemData.heureAffiche;
$item('#pLieu').label = itemData.salleAffiche;
$item('#pTitre').text = itemData.title;
$item('#pSousTitre').text = itemData.infoSpcialeSoustitre;
$item('#pCompagnie').label = itemData.organisateur;
$item('#pChoregraphe').text = itemData.chorgraphe;
$item('#pDetail').text = itemData.dtail;
$item('#pDebug').text = String(itemData.typeDevent) ;
if (itemData.compagnie) {
// it's the code that doesn't work : syntax itemData.compagnies.title is wrong
$item('#pCompagnie').label = itemData.Compagnies.title ;
//what is the OUTPUT-RESULT of this CONSOLE-CODE???
console.log(itemData.compagnie)
//you should get an object, right?
//open the results do a screenshot.
}
bjar
August 19, 2020, 7:20am
11
@russian-dima
import wixData from ‘wix-data’ ;
$w.onReady( function () {
async function buildFiltersAndPopulateRepeater() {#EvenementListe ’ ).data = await dataQuery.find().then((res) => res.items);
function initRepeater() {#EvenementListe ’ ).onItemReady(($item, itemData) => {// the following code use “Events” and it’s good #pDate ’ ).text = itemData.dateAffiche;#pHeure ’ ).text = itemData.heureAffiche;#pLieu ’ ).label = itemData.salleAffiche;#pTitre ’ ).text = itemData.title;#pSousTitre ’ ).text = itemData.infoSpcialeSoustitre;#pChoregraphe ’ ).text = itemData.chorgraphe;#pDetail ’ ).text = itemData.dtail;
**// it's the code use "Compagnies" that doesn't work : syntax ???**
$item( ' [#pCompagnie](https://www.wix.com/corvid/forum/search/~num~pCompagnie) ' ).label = itemData.Compagnies.title ;
}
@bjar
Hmmm i tried to reconstruct your issue, but a couldn’t…
Run this code and take a look in CONSOLE at your RESULTS.
async function buildFiltersAndPopulateRepeater() {
let dataQuery = wixData.query('Events').include('Compagnies');
dataQuery.find()
.then((results) => {
console.log(results)
})
}
This is also very interessting, because this is exactly what you get…(marked in blue). You get also the ID and not a referenced value.
Another idea would be, just take this ID (which should represent the current item-ID) and do a second query with FILTER for this ID in “Compagnies” database.
wixData.query("Compagnies")
.find()
.eq ("THE RIGHT COLUMN WHERE TO SEARCH", HERE THE INCLUDED-ID)
.then( (results) => {
if(results.items.length > 0) {
let firstItem = results.items[0]; //see item below
} else {
// handle case where no matching items found
}
} )
This is all i can help you. Perhaps some else have better ideas, or even the right solution.
bjar
August 20, 2020, 4:52pm
13
@russian-dima
to help better understand my problem, i simplify code in first post
but I still haven’t found the solution…
@bjar
When i tried to reconstruct a little bit of your project, i got the same result.
Perhaps one of the PROs can help here.@Ahmad @J . D.Giri Zano @ anthonyb
bjar
August 21, 2020, 5:16pm
15
@russian-dima
Hello,
With your advice, I made several tests :
Test 1 :
let dataQuery = wixData.query('Events').include('Compagnies');
console.log result :
I receive 50 items of Events : exemple :
but i also receive this message
Test 2 :
i use field value of compagnie for query Compagnies
let dataQuery = wixData.query('Compagnies').eq('_id','facb7085-ebca-4e34-9cc3-fcd1aa0bae86');
i receive 1 item of Compagnies :
so there is a link between Events.compagnie and Compagnies._id
there is therefore an incomprehension in the use of include () ???
@bjar
bjar
August 21, 2020, 5:25pm
17
@russian-dima
@bjar
Or just try to search for similar issues, perhaps the wanswer for our question (ussue) is already given somewhere.
bjar
August 22, 2020, 2:00pm
19
I finally found the solution. It is not the name of the second collection that must be used in include, but the name of the field in the primary collection
let dataQuery = wixData.query('Events').include('compagnie');
where “compagnie” is key-field of “Events”, referring to collection “Compagnies”
function initRepeater() {
$w('#EvenementListe').onItemReady(($item, itemData) => {
...
$item('#btnCompagnie').label = itemData.compagnie.title ;
}) ;
} ;
. I will give it a second try tomorrow. 
