Searching for an item within a specific numerical range on Elastic Search

Question

Searching for an item within a specific numerical range on Elastic Search

In the Elastic Search, we have two fields called startid and endid. For example, startid is 3061410 and endid is 3061450. Whenever a number between 3061410 and 3061450 is inputted, the query should retrieve that specific item. To view the elastic index snapshot, please visit this link: Elastic index snapshot

The expected result snapshot can be found by clicking here: Click here

I attempted the following query but unfortunately did not obtain the anticipated outcome:

{ "range": { "startid": { "gte": parseInt(this.selectedOP_no),"lte":+parseInt(this.selectedOP_no)+40 } } }

Here, this.selectedOP_no represents a number within the range of startid and endid, such as 3061411

angular typescript elasticsearch elasticsearch-plugin elasticsearch-dsl

Answer 1

Answer №1

To effectively utilize the two fields, it is essential to establish two separate conditions, one for each field. This can be achieved through the following structure:

{ 
   "bool": {
      "filter": [
         {
            "range": { 
              "endid": { 
                 "gte": parseInt(this.selectedOP_no) + 40 
              } 
            } 
         },
         {
            "range": { 
              "startid": { 
                 "lte":+parseInt(this.selectedOP_no)
              } 
            } 
         }
      ]
   }
}

Answer 2

To effectively utilize the two fields, it is essential to establish two separate conditions, one for each field. This can be achieved through the following structure:

{ 
   "bool": {
      "filter": [
         {
            "range": { 
              "endid": { 
                 "gte": parseInt(this.selectedOP_no) + 40 
              } 
            } 
         },
         {
            "range": { 
              "startid": { 
                 "lte":+parseInt(this.selectedOP_no)
              } 
            } 
         }
      ]
   }
}

Searching for an item within a specific numerical range on Elastic Search

Answer №1

Similar questions

When working with an observable in an Angular Material table, the *ngIf directive may not function as expected

Utilizing NGRX reducers with a common state object

Attempting to transmit the chosen value, extracted from the selection, into a function, repetitively and multiple times, within an array

Using Nestjs to inject providers into new instances of objects created using the "new" keyword

I need help figuring out how to showcase the following object in an Angular 5 HTML file

Using a jQuery plugin within an Angular 2 component: A step-by-step guide

Building stateless functional components in React using Typescript version 0.14

strange complications with importing TypeScript

managing commitments in TypeScript

The property y is not found on type x during property deconstruction

Angular 9 issue: Unexpected characters are being appended to the route URL when using queryParams

Arrange the angular datatables in a specific order without displaying the usual user interaction triangles

Limit pasted content in an Angular contenteditable div

"Enhancing the functionality of @angular/fire by transitioning from version 6.x to 7.x

Is Your IIS Serving Outdated Website Content?

Is the slow loading time of the Dev browser due to the large size of the vendor.js file

How to transfer files between Dropbox and AWS S3 using Angular 5

Tips for implementing a reusable component in Angular 2

Is it possible to downgrade the AngularCLI version from 1.0.0-beta.30 to 1.0.0-beta.26 on a global scale?

Taking advantage of Input decorator to access several properties in Angular 2