An ever-growing OData Reference

My way of explaining each function with as much detail as I can. You'll find suggestions, best practices, things to avoid, and limitations.

Last updated May 2026

Experience

I'll include all my experiences (good and bad) working with the functions.

For everyone

I want people to use it and share it. So I won't put any restriction on it on this reference.

By everyone

Please contribute! The better I can make it, the better it will be for everyone.

Lots of places

I learn from lots of places, so some things may be found elsewhere.

Operator (8)

Combines multiple conditions where all must be true.

Filters records where a field exactly matches a value.

Filters records where a field is strictly greater than a value.

Filters records where a field is greater than or equal to a value.

Filters records where a field is strictly less than a value.

Filters records where a field is less than or equal to a value.

Filters records where a field does not match a value.

Filters records where at least one condition is true.

Filters records where a field begins with a given string.

Checks whether one string contains another. The value comes first, then the field.