Azure / Azure/azure-cli

Where to find OData supported query operators in --filter parameter

Open
#14,277 7 comments 2 reactions 1 assignee Claimed by @jiasli View on GitHub
act-identity-squad customer-reported feature-request Graph Output Query Service Attention
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

Hi,

In several Azure CLI commands, you can use a `--filter` parameter to use OData syntax to filter your query.
It's seems that all OData operators aren't supported.

You can do:
`az ad app list --filter "displayName eq 'myAppRegistrationDisplayNameHere'"`

Or:
`az ad app list --filter "startswith(displayName,'myAppRegistration')"`

But you can't use endswith;
`az ad app list --filter "endswith(displayName,'appRegistrationEnd')"`
You get an error: `Unsupported Query`

I didn't find any documentation listing this information.
Is there a documentation somewhere that list all supported OData operators when using Azure CLI `--filter` parameter ?

Thank you

PS: Using Azure CLI 2.8.0

---
#### Document Details

⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*

* ID: 921aa920-c25f-5227-aabb-49116da38fa7
* Version Independent ID: 9b5a53ad-edf8-4d89-f8e6-cde01b7866f6
* Content: [az ad app](https://docs.microsoft.com/en-us/cli/azure/ad/app?view=azure-cli-latest#az-ad-app-list)
* Content Source: [src/azure-cli/azure/cli/command_modules/role/_help.py](https://github.com/Azure/azure-cli/blob/dev/src/azure-cli/azure/cli/command_modules/role/_help.py)
* Service: **active-directory**
* GitHub Login: @rloutlaw
* Microsoft Alias: **routlaw**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.