Filter query syntax error - List items in table

(0) Share

Report

Posted on by ConsultantIT

110

Hi,

I try to filter an Odata query on a Primary position that is assigned to an employee.

I used a connector with D365 Fin & Ops.

An employee can be assigned to several positions, but I only want the Primary position that he is assigned to.

The part with PersonnelNumber eq '000034' works fine! But when I try to add the primary position query, it doesn't work anymore...

Here are the tests I did:

PersonnelNumber eq '000034' and IsPrimaryPosition eq 'Yes'

PersonnelNumber eq '000034' and IsPrimaryPosition eq Yes

Here is the field I want to filter on: it is a Yes/No checkbox field.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Frog64

Try

PersonnelNumber eq '000034' and IsPrimaryPosition eq true

Was this reply helpful? Yes No
ConsultantIT 110 on at

Like (0)

Report

Hi @abm,

I tried but it doesn't work: An error has occurred. A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.DataEntities.NoYes' and 'Edm.Boolean' for operator kind 'Equal'.

Was this reply helpful? Yes No
ConsultantIT 110 on at

Like (0)

Report
When I look at the output of this step, here is the result:
"IsPrimaryPosition":"Yes"
I tried:
IsPrimaryPosition eq 'true'
IsPrimaryPosition eq 'True'
IsPrimaryPosition eq 'Yes'
IsPrimaryPosition eq 'yes'
IsPrimaryPosition eq '1'

Does someone have an idea?

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Frog64

Thanks for the update. If your output is 'Yes' then it should work with IsPrimaryPosition eq 'Yes'

try

IsPrimaryPosition eq 1

Was this reply helpful? Yes No
ConsultantIT 110 on at

Like (1)

Report

I already tried but it doesn't work 😥

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Frog64

I don't have D365 Fin & Ops to try this. Hopefully someone from community help you soon.

Thanks

Was this reply helpful? Yes No
yaggii 4 on at

Like (1)

Report

Try this:
IsPrimaryPosition eq Microsoft.Dynamics.DataEntities.'Yes'

Was this reply helpful? Yes No
Verified answer

Heartholme 1,278 Super User 2024 Season 1 on at

Like (1)

Report

Just solved this one, updating this for future users to see:

@Frog64

This is the correct way to solve this:

IsPrimaryPosition eq Microsoft.Dynamics.DataEntities.NoYes'No'

IsPrimaryPosition eq Microsoft.Dynamics.DataEntities.NoYes'Yes'

So, AnyBooleanColumnHeader eq Microsoft.Dynamics.DataEntities.NoYes'No'

If you're in the US, you might have to replace 'Yes' with ’Yes’.

Best Regards

Heartholme

Was this reply helpful? Yes No