Search into several databases and show all results in one table

Ask the community
, , ,
7

@dominic-dearlove You’re welcome.
And f you like the code to be more compact (it won’t affect performance in any noticeable way), you can do:

import wixData from 'wix-data'  
$w.onReady(function () { 
 $w("#resultsTable").columns = [/*put here all the columns as you did*/];
$w('#searchButton1').onClick(() => { 
const queries = ["Toppu1997", "Amada3"].map(collection => wixData.query(collection)             
   .contains("title", $w("#searchinput").value)             
   .or(wixData.query(collection)                 
   .contains("featuring_pkmn", $w("#searchinput").value));
);
   Promise.all(queries.map(q => q.find()))
  .then(r => {
    $w("#resultsTable").rows = r[0].items.concat(r[1].items);
  })
})
})