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.
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'.
When I look at the output of this step, here is the result:
IsPrimaryPosition eq 'true'
IsPrimaryPosition eq 'True'
IsPrimaryPosition eq 'Yes'
IsPrimaryPosition eq 'yes'
IsPrimaryPosition eq '1'
Does someone have an idea?