How to filter Odata with multiple enum value D365

(0) Share

Report

Posted on by it.dev

Hi All,

How could i filter odata with multiple enum value? I tried using this filter on the postman and not success

$filter=Type eq Microsoft.Dynamics.DataEntities.RateType'OC' And Type eq Microsoft.Dynamics.DataEntities.RateType'C'

Thanks

Masha

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Masha,

You need to use 'OR' instead of 'AND' as enum field can't contain more than one value and 'AND' condition will always return false.

Was this reply helpful? Yes No
it.dev 28 on at

Like (0)

Report

Hi Sergei,

I tried it with or and still not success

Thanks,

Masha

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Masha,

Do you get any data if you just filter by one of the enum value (without 'and' or 'or' condition)?

Was this reply helpful? Yes No
it.dev 28 on at

Like (0)

Report

Hi Sergei,

Yes i can get the data if filter only one of the enum

Thanks

Masha

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Masha,

Could you, please, provide the full url you are using?

At least for me 'or' condition is working fine, maybe you have other parameters in the url?

<MyUrl>/data/SalesOrderHeadersV2?$filter=SalesOrderStatus eq Microsoft.Dynamics.DataEntities.SalesStatus'Backorder' or SalesOrderStatus eq Microsoft.Dynamics.DataEntities.SalesStatus'Canceled'

Was this reply helpful? Yes No
it.dev 28 on at

Like (0)

Report

Hi Sergei,

this is my url

<MyUrl>/data/RateTypeEntity?$filter=Type eq Microsoft.Dynamics.DataEntities.RateType'OC' And Type eq Microsoft.Dynamics.DataEntities.RateType'C'

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Masha,

But it's still using 'And' keyword.

Try to use that example <MyUrl>/data/RateTypeEntity?cross-company=true&$filter=Type eq Microsoft.Dynamics.DataEntities.RateType'OC' or Type eq Microsoft.Dynamics.DataEntities.RateType'C'

Was this reply helpful? Yes No
Suggested answer

Deekshit Addepalli on at

Like (0)

Report

If you want to return values corresponding to both enums, then you would use the binary "OR" which roughly translates to "AND" in english :)

If you use AND in your expression (URL) then its looking to see if there is a match that satisfies RateType=OC and RateType=C for the same record.

Was this reply helpful? Yes No
it.dev 28 on at

Like (0)

Report

Hi Sergei and Deekshit,

Still not success either use AND / OR. Here's the error i got in the postman

"Syntax error at position 90 in 'Type eq Microsoft.Dynamics.DataEntities.RateType'OC' OR Type eq Microsoft.Dynamics.DataEntities.RateType'C''."

Thanks,

Masha

Was this reply helpful? Yes No
udaY-ch 5,128 on at

Like (0)

Report

Hi,

Try using enumValueName than enum value label.

Uday

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to filter Odata with multiple enum value D365

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to filter Odata with multiple enum value D365

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates