如何利用bodybuilder将数组转化为含Query、Filter的Elasticsearch动态查询？

Got it, let's walk through how to turn your queryArr into a valid Elasticsearch query using bodybuilder. The key is to iterate over your array and map each item's type to the corresponding bodybuilder method—super straightforward once you see the pattern.

Step-by-Step Implementation #

First, make sure you've installed the bodybuilder package (if you haven't already: npm install bodybuilder). Then use this code to build your query:

const bodybuilder = require('bodybuilder');

let queryArr = [ 
  { type: 'query', field: 'message', input: 'this is a test' }, 
  { type: 'filter', field: 'user', input: 'sample' }, 
  { type: 'notfilter', field: 'user', input: 'demo' }, 
  { type: 'query', field: 'name', input: 'test' } 
];

// Initialize a bodybuilder instance
let queryBuilder = bodybuilder();

// Loop through your array and build the query
queryArr.forEach(item => {
  switch (item.type) {
    case 'query':
      // Use `match` for full-text search (adjust to `match_phrase` if you need exact phrase matches)
      queryBuilder = queryBuilder.query('match', item.field, item.input);
      break;
    case 'filter':
      // Use `term` for exact matches (ideal for keyword/non-text fields; use `match` if filtering text)
      queryBuilder = queryBuilder.filter('term', item.field, item.input);
      break;
    case 'notfilter':
      // Exclude documents matching this condition
      queryBuilder = queryBuilder.notFilter('term', item.field, item.input);
      break;
    default:
      console.warn(`Skipping unknown query type: ${item.type}`);
  }
});

// Generate the final Elasticsearch query body
const elasticsearchQuery = queryBuilder.build();

// Log the result to verify
console.log(JSON.stringify(elasticsearchQuery, null, 2));

What the Output Looks Like #

When you run this code, it will generate a properly structured Elasticsearch query that combines your queries and filters:

{
  "query": {
    "bool": {
      "must": [
        { "match": { "message": "this is a test" } },
        { "match": { "name": "test" } }
      ],
      "filter": [
        { "term": { "user": "sample" } },
        { "bool": { "must_not": [ { "term": { "user": "demo" } } ] } }
      ]
    }
  }
}

Customization Tips #

• If you need a different query type (like match_phrase, range, or wildcard), just replace the first argument in query() or filter() (e.g., query('match_phrase', item.field, item.input)).
• For text fields in filters, you might want to use match instead of term to leverage Elasticsearch's text analysis.
• Bodybuilder automatically handles combining multiple queries into the bool.must clause, filters into bool.filter, and not-filters into nested bool.must_not clauses—perfect for complex combinations.

内容的提问来源于stack exchange，提问作者Etherealm