---
metadata:
  - name: generator
    content: Diplodoc Platform v5.57.3
alternate:
  - https://ydb-platform--ydb.viewer.diplodoc.com/en/recipes/json-search/index.md
  - https://ydb-platform--ydb.viewer.diplodoc.com/ru/recipes/json-search/index.md
  - href: https://ydb-platform--ydb.viewer.diplodoc.com/en/recipes/json-search/index.md
    type: text/markdown
    title: Markdown version
  - href: https://ydb-platform--ydb.viewer.diplodoc.com/en/llms.txt
    type: text/markdown
    title: llms.txt
sourcePath: en/core/recipes/json-search/index.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb-platform--ydb.viewer.diplodoc.com/en/llms.txt

# Recipes for searching JSON documents

This section contains ready-made recipes for using [JSON indexes](https://ydb-platform--ydb.viewer.diplodoc.com/en/dev/json-indexes.md) to efficiently select data based on the contents of columns of type `Json` and `JsonDocument`.

The recipes are built around the [JSON_EXISTS](https://ydb-platform--ydb.viewer.diplodoc.com/en/yql/reference/builtins/json.md) and [JSON_VALUE](https://ydb-platform--ydb.viewer.diplodoc.com/en/yql/reference/builtins/json.md) functions with [JsonPath](https://ydb-platform--ydb.viewer.diplodoc.com/en/yql/reference/builtins/json.md#jsonpath) expressions. To guarantee index usage, all examples use explicit access via `VIEW IndexName`.

* [JSON index – quick start](https://ydb-platform--ydb.viewer.diplodoc.com/en/recipes/json-search/json-index-quickstart.md) — minimal scenario: creating a table, an index, inserting data, and basic queries.
* [Catalog with nested attributes](https://ydb-platform--ydb.viewer.diplodoc.com/en/recipes/json-search/json-index-catalog.md) — example of a product catalog with nested attributes, range conditions, and searching nested arrays.
* [Parameterized queries and JsonPath variables](https://ydb-platform--ydb.viewer.diplodoc.com/en/recipes/json-search/json-index-parameters.md) — parameterized queries and passing variables to JsonPath via the `PASSING` section.
* [Checking field type and path existence](https://ydb-platform--ydb.viewer.diplodoc.com/en/recipes/json-search/json-index-typecheck.md) — checking the field type and path existence using JsonPath methods.

Before running the examples, make sure that [JSON index support is enabled](https://ydb-platform--ydb.viewer.diplodoc.com/en/reference/configuration/feature_flags.md) on the cluster.