numericFilters

Type: list of strings

Engine default: []

Parameter syntax

'numericFilters' => [
  'numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value',
  'attribute:lower_value TO higher_value',
  ...
]

numericFilters: [
  'numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value',
  'attribute:lower_value TO higher_value',
  ...
]

numericFilters: [
  'numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value',
  'attribute:lower_value TO higher_value',
  ...
]

'numericFilters': [
  'numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value',
  'attribute:lower_value TO higher_value',
  ...
]

numericFilters = [
  "numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value",
  "attribute:lower_value TO higher_value"
]

numericFilters {
    and {
        // "numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value"
        comparison("attribute", NumericOperator.Less, 0f)
        comparison("attribute", NumericOperator.LessOrEquals, 0f)
        comparison("attribute", NumericOperator.Equals, 0f)
        comparison("attribute", NotEquals, 0f)
        comparison("attribute", Greater, 0f)
        comparison("attribute", GreaterOrEquals, 0f)

        comparison("attribute", GreaterOrEquals, 0f, isNegated = true) // Negate a numeric filter
    }
    or {
        // "attribute:lowerBound TO upperBound"
        range("attribute", 0..10)
        range("attribute", 0f, 10f)
    }
}

.NumericFilters(@"
  numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value,
  attribute:lower_value TO higher_value
")

.setNumericFilters(Arrays.asList(
  "numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value",
  "attribute:lower_value TO higher_value",
  ...
))

opt.NumericFilter("numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value")
opt.NumericFilter("attribute:lower_value TO higher_value")

numericFilters = Some(Seq(
  "numeric_attribute [= | != | > | >= | < | <=](#numeric-comparisons) numeric_value",
  "attribute:lower_value TO higher_value"
))

Can be used in these methods:
search, browseObjects, deleteBy, searchForFacetValues, generateSecuredApiKey, addApiKey, updateApiKey search, browse_objects, delete_by, search_for_facet_values, generate_secured_api_key, add_api_key, update_api_key search, browseObjects, deleteBy, searchForFacetValues, generateSecuredApiKey, addApiKey, updateApiKey search, browse_objects, delete_by, search_for_facet_values, generate_secured_api_key, add_api_key, update_api_key search, browse, deleteBy, searchForFacetValues, generateSecuredApiKey, addAPIKey, updateAPIKey search, browseObjects, deleteObjectBy, searchForFacetValues, generateSecuredApiKey, addApiKey, updateApiKey Search, Browse, DeleteBy, SearchForFacetValues, GenerateSecuredApiKey, AddApiKey, UpdateApiKey Search, browse, deleteBy, searchForFacetValues, generateSecuredApiKey, addApiKey, updateApiKey Search, BrowseObjects, DeleteBy, SearchForFacetValues, GenerateSecuredAPIKey, AddAPIKey, UpdateAPIKey search, browse index, delete by, search into facet values, generateSecuredApiKey, add key, update key

See code examples

About this parameter

Filter on numeric attributes.

The filters parameter provides an easier to use, SQL-like syntax. We recommend using it instead of this setting.

Numeric Comparisons

Format: ${attributeName} ${operator} ${operand}
Example: inStock = 1.

Supported operators are <, <=, =, !=, >= and >, with the same semantics as in virtually all programming languages.

Numeric Range

Format: ${attributeName}:${lowerBound} TO ${upperBound}
Example: price:5.99 TO 100

${lowerBound} and ${upperBound} must be numeric. Both are inclusive.

Usage notes

No boolean operators: You cannot use boolean operators like AND and OR.
Multiple filters: If you specify multiple filters, they are interpreted as a conjunction (AND). If you want to use a disjunction (OR), use a nested array.
Supported values: You can use positive or negative numbers whose absolute value is up to 4611686018427387.
Precision limit: numeric filters support up to the third decimal point. Digits after the fourth decimal point are lost when filtering.

Examples

Apply numeric filters on a search query

Copy

1
2
3
4
5
6
7
8
9
$results = $index->search('query', [
  'numericFilters' => [
    [
      "inStock = 1",
      "deliveryDate < 1441755506"
    ],
    "price < 1000"
  ]
]);

1
2
3
4
5
6
7
8
9
10
11
index.search('query', {
  numericFilters: [
    [
      'inStock = 1',
      'deliveryDate < 1441755506'
    ],
    'price < 1000'
  ]
}).then(({ hits }) => {
  console.log(hits);
});

1
2
3
4
5
6
7
8
9
results = index.search('query', {
    'numericFilters': [
        [
            "inStock = 1",
            "deliveryDate < 1441755506"
        ],
        "price < 1000"
    ]
})

1
2
3
4
5
6
7
8
9
10
11
let query = Query("query")
  .set(\.numericFilters, to: [
    .or("inStock = 1", "deliveryDate < 1441755506"),
    "price < 1000"
  ])

index.search(query: query) { result in
  if case .success(let response) = result {
    print("Response: \(response)")
  }
}

1
2
3
4
5
6
7
8
index.Search<Book>(new Query("query")
{
    NumericFilters = new List<List<string>> 
    { 
      new List<string> { "inStock = 1", "deliveryDate < 1441755506"  },
      new List<string> { "price < 1000" }
    };
});

1
2
3
4
5
6
7
8
9
10
11
index.search(
  new Query("query").setNumericFilters(
          Arrays.asList(
                  Arrays.asList(
                          "inStock = 1",
                          "deliveryDate < 1441755506"
                  ),
                  Collections.singletonList("price < 1000")
          )
  )
);

1
2
3
4
5
6
7
8
9
10
11
12
client.execute {
  search into "myIndex" query Query(
    query = Some("query"),
    numericFilters = Some(Seq(
      Some(Seq(
        "inStock = 1",
        "deliveryDate < 1441755506"
      )),
      "price < 1000"
    ))
  )
}

1
2
3
4
5
6
7
8
9
10
11
12
13
val query = query("query") {
    numericFilters {
        or {
            comparison("inStock", Equals, 0f)
            comparison("deliveryDate", Less, 1441755506)
        }
        and {
            comparison("price", Less, 1000)
        }
    }
}

index.search(query)

[["inStock = 1", "deliveryDate < 1441755506"], "price < 1000"] translates as (inStock = 1 OR deliveryDate < 1441755506) AND price < 1000

Did you find this page helpful?

numericFilters

About this parameter

Usage notes

Examples

Apply numeric filters on a search query

On this page