How to filter baseenum in OData ?

(2) Share

Report

Posted on by Teevo

395

Hi guys,

When filtering Odata, as per my understanding, we need to use the keyword /eq/ for equal or /ne/ or not equal.

How to filter field with BaseEnum Type ? for example I want to filter warehouses with Type not Transit

In Postman, I hit this error:

/message/: /An error has occurred./,

/message/: /A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.DataEntities.InventLocationType' and 'Edm.Int32' for operator kind 'NotEqual'./,

Thanks

I have the same question (0)

All responses (8)

Answers (3)

Verified answer

Martin Dráb 237,892 Most Valuable Professional on at

Like (1)

Report

It should be something like WarehouseType ne Microsoft.Dynamics.DataEntities.InventLocationType'Transit'.

Was this reply helpful? Yes No
Verified answer

Mohamed Amine Mahmoudi 26,398 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Teevo,

Please refer to this :

https://shootax.blogspot.com/2020/06/d365fo-odata-how-to-filter-on-enum.html

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

Hi Teevo,

Martin is correct. You can read more about how to use OData with Dynamics 365 F&O entities on Microsoft Learn: Open Data Protocol (OData) - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
Teevo 395 on at

Like (0)

Report

Hi Martin,

Is that also valid inside Postman ?

I had this error though:

Was this reply helpful? Yes No
Teevo 395 on at

Like (0)

Report

Hi all,

Sorry. I overlooked at the "dot" after the BaseEnum name, which supposed to not needed.

Issue solved.

I hope I can mark as resolved. If not, kindly help to mark all answers.

Thanks.

Was this reply helpful? Yes No
Martin Dráb 237,892 Most Valuable Professional on at

Like (1)

Report

Yes, sorry, it was my mistake when copying the enum type name.

Was this reply helpful? Yes No
Teevo 395 on at

Like (0)

Report

Hi Martin,

No problem. Kindly help to mark all answered as resolution ?

Many Thanks.

Was this reply helpful? Yes No
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi Teevo,

Are you still facing the same issue when verifying answers? Because the community mentioned that the issue is resolved now. So please confirm if it's still not solved so that we raise it

Was this reply helpful? Yes No