# groonga - An open-source fulltext search engine and column store.

- 日本語版はこちら

### Navigation

- index
- next |
- previous |
- Groonga v5.0.1-42-g4d10df1 documentation »
- 7. Reference manual »
- 7.3. Command »

# 7.3.22. `logical_range_filter`

## 7.3.22.1. Summary

Note

This command is an experimental feature.

New in version 5.0.0.

TODO: Write summary

## 7.3.22.2. Syntax

The required parameters are `logical_table` and `shard_key`:

    logical_range_filter
                  logical_table
                  shard_key
                  [min]
                  [min_border]
                  [max]
                  [max_border]
                  [order]
                  [filter]
                  [offset]
                  [output_columns]

## 7.3.22.3. Usage

Register `sharding` plugin to use `logical_range_filter` command in advance.

## 7.3.22.4. Parameters

This section describes parameters of `logical_range_filter`.

### 7.3.22.4.1. Required parameter

There are required parameters, `logical_table` and `shard_key`.

#### 7.3.22.4.1.1. `logical_table`

Specifies logical table name. It means table name without "_YYYYMMDD" postfix. If you use actual table such as "Logs_20150203", "Logs_20150203" and so on, logical table name is "Logs".

#### 7.3.22.4.1.2. `shard_key`

Specifies column name which is treated as shared key in each parted table.

### 7.3.22.4.2. Optional parameters

There are optional parameters.

#### 7.3.22.4.2.1. `min`

Specifies the min value of `shard_key`

#### 7.3.22.4.2.2. `min_border`

Specifies whether the min value of borderline must be include or not. Specify `include` or `exclude` as the value of this parameter.

#### 7.3.22.4.2.3. `max`

Specifies the max value of `shard_key`.

#### 7.3.22.4.2.4. `max_border`

Specifies whether the max value of borderline must be include or not. Specify `include` or `exclude` as the value of this parameter.

#### 7.3.22.4.2.5. `order`

#### 7.3.22.4.2.6. `filter`

#### 7.3.22.4.2.7. `offset`

#### 7.3.22.4.2.8. `output_columns`

## 7.3.22.5. Return value

    [HEADER, LOGICAL_FILTERED]

### Navigation

- index
- next |
- previous |
- Groonga v5.0.1-42-g4d10df1 documentation »
- 7. Reference manual »
- 7.3. Command »