如何使用多选下拉列表过滤组合搜索MongoDB文档？

// HTML代码
<select id="filterOptions" multiple>
  <option value="option1">Option 1</option>
  <option value="option2">Option 2</option>
  <option value="option3">Option 3</option>
</select>

<table id="resultTable">
  <thead>
    <tr>
      <th>Field 1</th>
      <th>Field 2</th>
      <th>Field 3</th>
    </tr>
  </thead>
  <tbody>
    <!-- 查询结果将动态添加到这里 -->
  </tbody>
</table>

// JavaScript代码
const filterOptions = document.getElementById('filterOptions');
const resultTable = document.getElementById('resultTable');

filterOptions.addEventListener('change', () => {
  const selectedOptions = Array.from(filterOptions.selectedOptions).map(option => option.value);

  // 构建查询对象
  const query = {
    $and: selectedOptions.map(option => ({ field: option }))
  };

  // 发起数据库查询
  fetch('/api/search', {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json'
    },
    body: JSON.stringify(query)
  })
  .then(response => response.json())
  .then(data => {
    // 清空表格内容
    resultTable.innerHTML = '';

    // 将查询结果添加到表格中
    data.forEach(doc => {
      const row = document.createElement('tr');
      const field1Cell = document.createElement('td');
      const field2Cell = document.createElement('td');
      const field3Cell = document.createElement('td');

      field1Cell.textContent = doc.field1;
      field2Cell.textContent = doc.field2;
      field3Cell.textContent = doc.field3;

      row.appendChild(field1Cell);
      row.appendChild(field2Cell);
      row.appendChild(field3Cell);

      resultTable.appendChild(row);
    });
  })
  .catch(error => {
    console.error('Error:', error);
  });
});