search in my database

Ask the community
,
1

hi I´m trying to do a search tool in my page and i´m not having sucess

how can i do a multiple dropbox choice an then see the result in the tablle
just an exemple
the user select the choises in dropboxes and then click on the search button
then the result appear in the table under

i´m trying to set with these codes
but i´m not having success
import wixData from ‘wix-data’;

//For full API documentation, including code examples visit http://wix.to/94BuAAs

$w.onReady(function () {
//TODO: import wixData from ‘wix-data’;
});

export function button1_click() {
wixData.query(‘bd_master’)
.contains(‘uf’, $w(‘#selection1’).value)
.or(wixData.query().contains(‘cidade’,$w(“#selection12”).value))
.or(wixData.query().contains(‘segmento’,$w(“#selection8”).value))
.or(wixData.query().contains(‘tipoDeAtuacao’,$w(“#selection2”).value))
.or(wixData.query().contains(‘subTipo’,$w(“#selection8”).value))
.find()
.then(res => {
$w(‘#tabela’).rows = res.items;
});

}

THE WIX MSG ERROR IS THESE
Wix code SDK error: The value parameter of item at index 0 that is passed to the options method cannot be set to the value . It must be of type string.

i´m not finding any solution can you guys help me ?

thank´s a lot

1 Like