OData query to filter objects based on multiple Ids

Question

Consider that api response without any filters as below,

[
        {
            "Account": {
                "AccountID": "1",
                "Name": "Acc1"

            }
        },      
        {
            "Account": {
                "AccountID": "2",
                "Name": "Acc2"

            }
        },              
        {
            "Account": {
                "AccountID": "3",
                "Name": "Acc3"

            }
        },
        {
            "Account": {
                "AccountID": "4",
                "Name": "Acc4"

            }
        }
        ...
        ...
]

Im using odata query to filter accounts as below, when I have array of account ids.

.......apiurl?$filter=Account/AccountID eq '1' OR Account/AccountID eq  '2' OR Account/AccountID eq '3'

This seems working. But when the account ids array has more values then the uqi query length gets increase.

Is there any other option to use the field only once Account/AccountID in uri to check against array of Ids.

Thanks in advance.

Does this answer your question? [OData "where ID in list" query](https://stackoverflow.com/questions/7745231/odata-where-id-in-list-query) — Panagiotis Kanavos, Feb 24 '21 at 08:02

score 3 · Answer 1 · answered Feb 27 '21 at 16:11

When you are trying to filter for same property but different value, it is good practice to use in.

In your case, this would look like

.......apiurl?$filter=Account/AccountID in ('1', '2', '3')

Please pay attention also on queries towards Database. If you have queries like WHERE AccountId = '1' OR AccountId = '2' to switch them to WHERE AccountId IN ('1', '2') on server side - just suggestion for optimization.

OData query to filter objects based on multiple Ids

1 Answers1