Skip to content

Query any JSON child object regardless of index #2898

@aaronhudon

Description

@aaronhudon

The issue

I am seeking clarification on how to query any child JSON object, regardless of index.
For example, in the documentation, we see:
.Where(e => e.Customer.GetProperty("Orders")[1].GetProperty("Price").GetInt32() = 8)

This is great to look for the 2nd order (index1) where the price is 8.

How can we write a query that looks for any order in the child collection of orders, where the prices is 8?

Further technical details

Npgsql version: 4.1.3

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions