Below is my code from a lighbox that recives data:
export function table1_rowSelect(event) {
//Add your code for this event here:
let scope = $w.at(event.context);
let teamRecord = scope(‘#teamsDataset’).getCurrentItem();
wixWindow.openLightbox(‘schedule’, teamRecord);
}
From the data in teamRecord, how can I query Games(Schedule). Games(Schedule) has two fields home_team_id and away_team_id both that could contain a team ID that I receive on teamRecord.
Here is two queries that I have tried but to no success:
wixData.queryReferenced(“Schedule”, dataObj.team_id, “home_team_id”)
.then( (results) => {
if (results.items.length > 0) {
let firstItem = results.items[0]; //see item below
console.log((“woo hoo found a record”))
} else {
// handle case where no matching items found
console.log(“oh no, no recs found!!!”)
}
} )
. catch ( (error) => {
let errorMsg = error.message;
let code = error.code;
console.log(“first error”);
} );
wixData.query(“Schedule”)
.eq(“home_team_id”, dataObj.team_id)
.find()
.then( (results) => {
if (results.items.length > 0) {
let games = results.items;
let firstGame = games[0];
console.log(“found a record”);
console.log(firstGame);
} else {
// handle case where no matching items found
console.log(“oh no! found no results”);
}
} )
