Hello, thanks for answering ! I love that it’s possible.
But I don’t think I can achieve with only basic code skills.
Where do I integrate your code into my code ? I tried using it but i’m probably no where close
import wixData from 'wix-data'
$w.onReady(function () {
$w('#search').onClick(function () {
wixData.query("Toppu1997")
.contains("title", $w("#searchinput").value)
.or(wixData.query("Toppu1997")
.contains("featuring_pkmn", $w("#searchinput").value))
.find()
.then((results1) => {
let results1Items = results1.items;
console.log(results1Items);
wixData.query("Amada3")
.contains("title", $w("#searchinput").value)
.or(wixData.query("Amada3")
.contains("featuring_pkmn", $w("#searchinput").value))
.find()
.then((results2) => {
let results2Items = results2.items;
console.log(results2Items);
const allResults = results1Items.concat(results2Items);
console.log(allResults);
})
.then(allResults => {
$w('#resultsTable').rows = console.log(allResults);
});
})
})
$w("#resultsTable").columns = [
{
"id": "col1",
"dataPath": "stickernumber",
"label": "Sticker Number",
"width": 100,
"visible": true,
"type": "number"
} ,
{
"id": "col2",
"dataPath": "title",
"label": "Name",
"width": 100,
"visible": true,
"type": "string"
},
{
"id": "col3",
"dataPath": "Stickersetlist.title",
"label": "Set Name",
"width": 100,
"visible": true,
"type": "string"
},
{
"id": "col4",
"dataPath": "manu_year",
"label": "Year",
"width": 80,
"visible": true,
"type": "Number",
} ,
{
"id": "col5",
"dataPath": "type",
"label": "Type",
"width": 100,
"visible": true,
"type": "string",
} ,
{
"id": "col6",
"dataPath": "image",
"label": "Image",
"width": 300,
"visible": true,
"type": "image",
} ,
];
});