Searching multiple columns in a database

Ask the community
,
1

I am a beginner at coding and have learned a lot from this forum. Hope you can help me with this:

I would like to search multiple columns in a database. I have found this link , but it only explains how to search one column.

This is my current code:

import wixData from "wix-data"; 

let debounceTimer; 

export function SearchBox_keyPress(event, $w)

 { if (debounceTimer) { clearTimeout(debounceTimer); debounceTimer = undefined; } 
 
debounceTimer = setTimeout(() => {
  
  filter($w('#SearchBox').value, ); }, 500); } function filter(title) { 
  $w('#dataset1').setFilter(wixData.filter().contains('title', title)) }

All help is appreciated.

Thank you very much.

2

Hi,
You can learn how to create collection data search functionality here .
This tutorial helps to create a search that checks all columns and you can get the needed one in the results.

3

Hello thanks for trying to help!

the link you suggested talks about displaying the results in a table. I would like to display my results in a repeater.The repeater would be the same one that displays the entire database collection. You can see my current search here: https://www.pandemicity.org/clinical-research

Thank you.