Nested OData $filter with one field must equal and a second must not equal

🙋 Help
1

I am trying to filter on two variables.

  1. field MaterialNumber must equal a specific vale

  2. 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?

Thank you,
Jason

2

Resolved. removed single quotes from around null.