I am trying to filter on two variables.
field MaterialNumber must equal a specific vale
second field EquipmentNumber must not be null
Example postman query
https://whateverurlineedhere/api/se/ToolStringEquipmentUses?$filter=MaterialNumber eq ‘123456-003’ and EquipmentNumber ne ‘null’
returns all entries with the correct Materialnumber, but does not filter out the null Equipmentnumber entries. any ideas?