Search into several databases and show all results in one table

Ask the community
, , ,
5

P.S. but since you’re using uer input, you may want to run the queries in onClick event handler.
Like:

import wixData from 'wix-data'  
$w.onReady(function () { 
 $w("#resultsTable").columns = [/*put here all the columns as you did*/];
$w('#searchButton1').onClick(() => { 
 const query1 = wixData.query("Toppu1997")             
   .contains("title", $w("#searchinput").value)             
   .or(wixData.query("Toppu1997")                 
   .contains("featuring_pkmn", $w("#searchinput").value));

const query2 = wixData.query("Amada3")                     
  .contains("title", $w("#searchinput").value) 
  .or(wixData.query("Amada3")                 
  .contains("featuring_pkmn", $w("#searchinput").value));

   Promise.all([
      query1.find(),
      query2.find()
  ])
  .then(r => {
    $w("#resultsTable").rows = r[0].items.concat(r[1].items);
  })
})
})