Examples for Scalpel Filter Settings

---
type: expression
expression:
  expressions:
    - type: condition
      condition:
        type: Q
        Q:
          key: patient_name
          string: abc

---
type: expression
expression:
  operator:
    type: or
  expressions:
    - type: condition
      condition:
        type: Q
        Q:
          key: submission_count__gte
          number: 1

    - type: condition
      condition:
        type: Q
        Q:
          key: patient_name
          string: abc

---
exclude: true
type: expression
expression:
  operator:
    type: or
  expressions:
    - type: condition
      condition:
        type: Q
        Q:
          key: submission_count__gte
          number: 1
          exclude: true

    - type: condition
      condition:
        type: Q
        Q:
          key: deacivated_on__isnull
          boolean: true

---
type: expression
expression:
  operator:
    type: and
  expressions:
    - type: condition
      condition:
        type: Q
        Q:
          key: patient_name
          string: John Smith

    - type: condition
      condition:
        type: Q
        Q:
          key: submission_count__gte
          number: 1

    - type: condition
      condition:
        type: Q
        Q:
          key: message__status__in
          string_array:
            - DELIVERED
            - SENT

    - type: condition
      condition:
        type: Q
        Q:
          key: enrollment_date__gte
          datetime: "2018-06-01T00:00:00+00:00"

---
type: expression
expression:
  operator:
    type: or
  expressions:
    - type: expression
      expression:
        operator:
          type: and
        expressions:
          - type: condition
            condition:
              type: Q
              Q:
                key: submission_count__gte
                number: 1

          - type: condition
            condition:
              type: Q
              Q:
                key: patient_name
                string: abc

    - type: expression
      expression:
        operator:
          type: and
        expressions:
          - type: condition
            condition:
              type: Q
              Q:
                key: message__status__in
                string_array:
                  - DELIVERED
                  - SENT

          - type: condition
            condition:
              type: Q
              Q:
                key: enrollment_date__gte
                datetime: "2018-06-01T00:00:00+00:00"