# Query Orders Missing Alerts

> Perform Query Orders Missing Alerts through ClaimSoft.

Source: [https://genhealth.ai/docs/workflows/integrations/claim-soft/claimsoft_query_orders_missing_alerts](https://genhealth.ai/docs/workflows/integrations/claim-soft/claimsoft_query_orders_missing_alerts)

Integration: [ClaimSoft](https://genhealth.ai/docs/workflows/integrations/claim-soft.md)

- Handler: `claimsoft_query_orders_missing_alerts`

- Connection type: `claimsoft`

## Inputs

- `begin_date` — Begin Date (date, required)
  Required date in YYYY-MM-DD format.
- `end_date` — End Date (date, required)
  Required date in YYYY-MM-DD format.
- `billing_location_ids` — Billing Location Ids (json)
  Optional JSON value.
- `order_statuses` — Order Statuses (json)
  Optional JSON value.
  Options: 1 ("1"), 2 ("2"), 3 ("3"), 4 ("4"), 5 ("5"), 7 ("7"), 8 ("8")
- `search_text` — Search Text (text)
  Optional text value.
- `search_fields` — Search Fields (text)
  Optional text value.
  Default: `"PatientName,PatientAccountId,Order,Charge"`
- `no_alerts` — No Alerts (boolean)
  Optional true-or-false value.
  Default: `true`
- `show_deleted` — Show Deleted (boolean)
  Optional true-or-false value.
  Default: `false`
- `max_rows` — Max Rows (number)
  Optional numeric value.
  Default: `500`

## Outputs

- `success` — Success
- `total` — Total
- `rows` — Rows
- `order_ids` — Order Ids
- `filter_model` — Filter Model
- `query_params` — Query Params
- `truncated` — Truncated
- `error` — Error

Output schema completeness: `best_effort_declared`

## Safety

- External effect: `write`
- Confirmation recommended: no
- Retry safe: no
- Dry run supported: no

## Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

### Input schema

```json
{
  "type": "object",
  "required": [
    "begin_date",
    "end_date"
  ],
  "properties": {
    "end_date": {
      "type": "string",
      "format": "date",
      "description": "Required date in YYYY-MM-DD format.",
      "x-workflow-field-type": "date"
    },
    "max_rows": {
      "type": "number",
      "default": 500,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "no_alerts": {
      "type": "boolean",
      "default": true,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "begin_date": {
      "type": "string",
      "format": "date",
      "description": "Required date in YYYY-MM-DD format.",
      "x-workflow-field-type": "date"
    },
    "search_text": {
      "type": "string",
      "description": "Optional text value.",
      "x-workflow-field-type": "text"
    },
    "show_deleted": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "search_fields": {
      "type": "string",
      "default": "PatientName,PatientAccountId,Order,Charge",
      "description": "Optional text value.",
      "x-workflow-field-type": "text"
    },
    "order_statuses": {
      "enum": [
        "1",
        "2",
        "3",
        "4",
        "5",
        "7",
        "8"
      ],
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    },
    "billing_location_ids": {
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    }
  },
  "additionalProperties": false
}
```

### Output schema

```json
{
  "type": "object",
  "properties": {
    "rows": {},
    "error": {},
    "total": {},
    "success": {},
    "order_ids": {},
    "truncated": {},
    "filter_model": {},
    "query_params": {}
  },
  "additionalProperties": true
}
```