Search bar .contains(entire_dataset, "string" ) (not a column)

Ask the community
,
1

Hi,

I’m using this wix template to add a search bar and dropdown filters to my web.
The search bar is working on a specific column ‘articleTitle’ , with the following code:

import wixData from "wix-data";

$w.onReady(() => {
  loadContinents();
});

let lastFilterTitle;
let lastFilterContinent;
let debounceTimer;
export function iTitle_keyPress(event, $w) {
 if (debounceTimer) {
    clearTimeout(debounceTimer);
    debounceTimer = undefined;
  }
  debounceTimer = setTimeout(() => {
    filter($w('#iTitle').value, lastFilterContinent);  
  }, 500);
}

export function iContinent_change(event, $w) {
  filter(lastFilterTitle, $w('#iContinent').value);
}

function filter(title, continent) {
 if (lastFilterTitle !== title || lastFilterContinent !== continent) {
 let newFilter = wixData.filter();
 if (title)
      newFilter = newFilter.contains('articleTitle', title);
 if (continent)
      newFilter = newFilter.contains('continent', continent);
    $w('#dataset1').setFilter(newFilter);   
    lastFilterTitle = title; 
    lastFilterContinent = continent;
  }
}

function loadContinents() {
  wixData.query('Continents')
    .find()
    .then(res => {
 let options = [{"value": '', "label": 'All Continents'}];
      options.push(...res.items.map(continent => {
 return {"value": continent.title, "label": continent.title};
      }));
      $w('#iContinent').options = options;
    });

}

I wish to change the .contains( ) to search the entire dataset Articles and not a specific column.

newFilter = newFilter.contains('articleTitle', title); //old 
newFilter = newFilter.contains('entierDataset', continent); //new

P L Z H E L P : )

thanx
Noa

2

It’s hard to understand what exactly you mean by “entire dataset”. I guess you don’t want it to look-up inside the _id or _lastUpdated columns. So you should add details regarding what exactly you’re trying to achieve.