Filter query syntax error - List items in table

[Frog64]

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.

[abm]

Hi @Frog64 

Try 

PersonnelNumber eq '000034' and IsPrimaryPosition eq  true

[Frog64]

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'.

[Frog64]

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

[abm]

Hi @Frog64 

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

try

IsPrimaryPosition eq 1

[Frog64]

I already tried but it doesn't work 😥

[abm]

Hi @Frog64 

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

Thanks

[yaggii]

Try this: 

IsPrimaryPosition  eq Microsoft.Dynamics.DataEntities.'Yes'

[Heartholme · Accepted solution]

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