Mixing checkbox in search code

Ask the community
,
1

I very new on coding so sorry for being stupid.
i created a web search and i cant find a way to combine my boolean fields from the database
to the search results.
i just want that if the boolean is true on the database field then the item will be shown on the search results, and if not then it will not been shown.

another problem i have is that i have a field with numbers in my database and a minimum maximum fields in the search page and i try to make that if the number on the database is between the minimum and maximum it will be shown and if not then not be shown.

this is my search function code : (the onReady function is empty)

export function search () {

let aName = wixData.query(‘apartments’);
let boxName = wixData.query(‘search’);
let acBoxV = $w(“#acBox”).value;

    aName.contains('name', $w("#searchBar").value) 
    .or(aName.contains('nighberhood', $w("#searchBar").value)) 
    .and(aName.contains('type', $w("#typeBar").value))

// .and(boxName.contains(‘ac’, $w(“#acBox”).value))
.and($w(“#search”).setFilter(wixData.filter().contains(“ac”, acBoxV).value))

    .find() 

    .then(res => { 
    $w('#repeater1').data = res.items});

}

thanks agine and sorry for my bad english and experiment.

2

???