Search into several databases and show all results in one table

Ask the community
, , ,
10

@jonatandor35 Thanks again !

I get an error when i add “.include” into the code (cannot find name “include”, declaration or statement expected) and when I add .concat(r[2].items) to the results I only get results for two of the databases (the first one, and the third one), when it’s r[1], i get search results for the first and second database. I dont know if I added it correctly.

$w('#search').onClick(() => { 
const queries = ["Toppu1997", "ToppuSealGum1", "RetsudenHyperStickerCollection1"].map(collection => wixData.query(collection)             
   .contains("title", $w("#searchinput").value)             
   .or(wixData.query(collection)                 
   .contains("featuring_pkmn", $w("#searchinput").value)));
   .include('setName')

   Promise.all(queries.map(q => q.find()))

  .then(r => {
    $w("#resultsTable").rows = r[0].items.concat(r[2].items);

  })
})
})

Thank you :checkered_flag: