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)

Sort by

Verified answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!

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 30 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

I tried it with or and still not success

Thanks,

Masha

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

Like (0)

Report
Copy link

Link copied!

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 30 on at

Like (0)

Report
Copy link

Link copied!

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,097 on at

Like (0)

Report
Copy link

Link copied!

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 30 on at

Like (0)

Report
Copy link

Link copied!

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,097 on at

Like (0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 30 on at

Like (0)

Report
Copy link

Link copied!

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,175 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Try using enumValueName than enum value label.

Uday

Was this reply helpful? Yes No