Repeater showing all records when dropdown value is undefined

Ask the community
,
2

Hi! Try out:

wixData.query("Cities")
.contains("title", String($w('#citypick1').value)) // filters field "title" in the dataset
.find()
.then(results => {
  if ($w('#citypick1').value === '') { // if no value is selected in the dropdown box
    wixData.get("Cities", "6a8a6759-5e5d-4f1e-8c7a-9b6a44c4f2d4") // get a specific record by its ID
      .then(record => {
        $w('#citystrip').data = [record]; // show the specific record in the repeater
      });
  } else if (results.items.length > 0) { // if there are results matching the query...
    $w('#citystrip').data = results.items; //...show the filtered result
  } else { // if there are no results matching the query...
    $w('#citystrip').data = results.items[1]; // show record 2 of the dataset
  }
});