Contrived, almost exhaustive, example of a merged TNQL and CANQL generated DIR query

contrived_example.json

{
  "action.actioninitiated": {
    "equals": "QA"
  },
  "anomaly.prenatal.exists": {
    "equals": true
  },
  "diagnosis.providercode": {
    "equals": "RGT01"
  },
  "limit": {
    "equals": 27
  },
  "mother.birthdate": {
    "limits": ["1990-10-01", "1999-01-10"]
  },
  "mother.deathdate": {
    "limits": ["2015-08-01", "2015-08-01"]
  },
  "mother.fields_populated": {
    "equals": ["postcode", "nhsnumber"]
  },
  "patient.birthdate": {
    "limits": ["2015-06-22", "2015-06-22"]
  },
  "patient.dead": {
    "equals": true
  },
  "patient.deathdate": {
    "limits": ["2015-07-07", "2015-07-07"]
  },
  "patient.death_certificate": {
    "equals": false
  },
  "patient.expecteddeliverydate": {
    "limits": ["2015-06-20", "2015-06-25"]
  },
  "patient.fields_missing": {
    "equals": ["postcode", "birthdate"]
  },
  "patient.outcome": {
    "equals": "liveborn"
  },
  "patient.registry": {
    "equals": "68"
  },
  "patient.sex": {
    "equals": "1"
  },
  "staging.stage": {
    "begins": ["4"]
  },
  "testresults.postnatal.exists": {
    "equals": true
  },
  "treatment.providercode": {
    "equals": "RGN42"
  },
  "tumour.behaviour": {
    "equals": ["0", "1", "2"]
  },
  "tumour.diagnosisdate": {
    "limits": ["2010-08-01", "2010-10-31"]
  },
  "tumour.registry": {
    "equals": "Y0401"
  },
  "tumour.site_group": {
    "equals": 8
  },
  "tumour.statusofregistration": {
    "equals": ["F"]
  },
  "unprocessed_records.sources": {
    "equals": ["PAEDIATRIC"]
  }
}