QueryJSON

Example

{
    "eq": [
        {
            "field": "field1",
            "value": {
                "value": 12345
            }
        },
        {
            "not": true,
            "caseInsensitive": true,
            "field": "field12",
            "value": {
                "value": 12345
            }
        }
    ],
    "neq": [
        {
            "field": "field2",
            "value": {
                "value": 12345
            }
        }
    ],
    "like": [
        {
            "field": "field3",
            "value": {
                "value": 12345
            }
        }
    ],
    "lt": [
        {
            "field": "field4",
            "value": {
                "value": 12345
            }
        }
    ],
    "lte": [
        {
            "field": "field5",
            "value": {
                "value": 12345
            }
        }
    ],
    "gt": [
        {
            "field": "field6",
            "value": {
                "value": 12345
            }
        }
    ],
    "gte": [
        {
            "field": "field7",
            "value": {
                "value": 12345
            }
        }
    ],
    "in": [
        {
            "field": "field8",
            "values": [
                {
                    "value": 12345
                }
            ]
        }
    ],
    "nin": [
        {
            "field": "field9",
            "values": [
                {
                    "value": 12345
                }
            ]
        }
    ],
    "null": [
        {
            "not": true,
            "field": "field10"
        },
        {
            "field": "field11"
        }
    ],
    "limit": 10,
    "sort": [
        "field1 DESC",
        "field2"
    ]
}

Field Descriptions

Field Name	Description	Type
or	List of alternative statements	Statements[]
equal	Equal to	OpSingleVal[]
eq	Equal to (short name)	OpSingleVal[]
neq	Not equal to	OpSingleVal[]
like	Like	OpSingleVal[]
lessThan	Less than	OpSingleVal[]
lt	Less than (short name)	OpSingleVal[]
lessThanOrEqual	Less than or equal to	OpSingleVal[]
lte	Less than or equal to (short name)	OpSingleVal[]
greaterThan	Greater than	OpSingleVal[]
gt	Greater than (short name)	OpSingleVal[]
greaterThanOrEqual	Greater than or equal to	OpSingleVal[]
gte	Greater than or equal to (short name)	OpSingleVal[]
in	In	OpMultiVal[]
nin	Not in	OpMultiVal[]
null	Null	Op[]
limit	Query limit	int
sort	Query sort order	string[]

Statements

Field Name	Description	Type
or	List of alternative statements	Statements[]
equal	Equal to	OpSingleVal[]
eq	Equal to (short name)	OpSingleVal[]
neq	Not equal to	OpSingleVal[]
like	Like	OpSingleVal[]
lessThan	Less than	OpSingleVal[]
lt	Less than (short name)	OpSingleVal[]
lessThanOrEqual	Less than or equal to	OpSingleVal[]
lte	Less than or equal to (short name)	OpSingleVal[]
greaterThan	Greater than	OpSingleVal[]
gt	Greater than (short name)	OpSingleVal[]
greaterThanOrEqual	Greater than or equal to	OpSingleVal[]
gte	Greater than or equal to (short name)	OpSingleVal[]
in	In	OpMultiVal[]
nin	Not in	OpMultiVal[]
null	Null	Op[]

OpSingleVal

Field Name	Description	Type
not	Negate the operation	bool
caseInsensitive	Perform case-insensitive matching	bool
field	Field to apply the operation to	string
value	Value to compare against	RawJSON

OpMultiVal

Field Name	Description	Type
not	Negate the operation	bool
caseInsensitive	Perform case-insensitive matching	bool
field	Field to apply the operation to	string
values	Values to compare against	RawJSON[]

Op

Field Name	Description	Type
not	Negate the operation	bool
caseInsensitive	Perform case-insensitive matching	bool
field	Field to apply the operation to	string