How do i filter an array of json objects based on a object field?

[ericshufro]

Hello.  I am trying to filter out json objects from an array.  The goal is to:

1. Allow through the filter anyone whose job title is null.

2. Block anyone whose job title contains 'Director' or 'Manager'

3. Allow all remaining

I tried the following, but its not quite right and all objects seems to pass though.

@OR(equals(item()?['JobTitle'], null), or(not(contains(item()?['JobTitle'], 'Manager')), not(contains(item()?['JobTitle'], 'Director'))))

The data is formatted as:

[

  {

    "Mail": "a@y.com",

    "DisplayName": "John Doe 1",

    "JobTitle": "Director, Engineering",

    "AccountEnabled": true

  },

  {

    "Mail": "b@y.com",

    "DisplayName": "John Doe 2",

    "JobTitle": "Associate Director, Engineering",

    "AccountEnabled": true

  },

  {

    "Mail": "c@y.com",

    "DisplayName": "John Doe 3",

    "JobTitle": "Sr. Staff Engineer, Software",

    "AccountEnabled": true

  },

Thanks in advance.

-e

[Mira_Ghaly · Accepted solution]

@ericshufro 

Please use the below expression:

@and(not(contains(item()?['JobTitle'], 'Director')),not(contains(item()?['JobTitle'], 'Manager')))

[ericshufro]

Will this cover the null check?  Seems to still be an issue.

[ericshufro · Accepted solution]

Very close. 

See below.

@OR(equals(item()?['JobTitle'], null), and(not(contains(item()?['JobTitle'], 'Director')),not(contains(item()?['JobTitle'], 'Manager'))))