# View: dt_vector_backlog

**View Name:** dt_vector_backlog
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Reportsdd_Direct_Delivery, Reportsdd_Direct_Delivery.Customer_Master_Master, Reportsdd_Direct_Delivery.Dms_Delivery_Spec, Reportsdd_Direct_Delivery.Encoding_Queue + 1 more`
**File Path:** `dt_vector_backlog.view.lkml`

## Overview

- **File Size:** 2723 bytes
- **Lines of Code:** 94
- **Dimensions:** 11
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `store_id` | number |
| `store_name` | string |
| `priority` | number |
| `encoding` | string |
| `delivery` | string |
| `connection_limit` | number |
| `last_delivery` | date_time |
| `count_new` | number |
| `count_encoding` | number |
| `count_delivering` | number |
| `count_total` | number |

## Filters

- `encoder_id`

## Derived Table

```sql
sql:
WITH base_report AS (
    SELECT store_data.*,
        MAX(eqd.delivery_ended) AS last_delivery,
        COUNT( CASE WHEN eqd.status = 'new'
            THEN 1 ELSE NULL END ) AS count_new,
        COUNT( CASE WHEN (eqd.status LIKE 'ready_to_encode' OR eqd.status = 'encoding')
            THEN 1 ELSE NULL END ) AS count_encoding,
        COUNT( CASE WHEN (eqd.status LIKE 'ready_to_deliver' OR eqd.status LIKE 'queued_for_delivery' OR eqd.status  IN ('delivering', 'encoded'))
            THEN 1 ELSE NULL END ) AS count_delivering
    FROM orchard_app_reporting_v2.reportsdd_direct_delivery.encoding_queue_detail eqd
        INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.encoding_queue eq ON eqd.encoding_queue_id = eq.encoding_queue_id
        INNER JOIN (
            SELECT
                cmm.customer_master_master_id AS store_id,
                cmm.customer_name AS store_name,
                cmm.priority,
                dds.encoding,
                dds.delivery,
                dds.connection_limit
            FROM orchard_app_reporting_v2.reportsdd_direct_delivery.customer_master_master cmm
                LEFT JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.dms_delivery_spec dds ON cmm.customer_master_master_id = dds.dms_master_master_id
            WHERE dds.order_type = 'release'
                AND (dds.delivery <> 'n' OR dds.delivery IS NULL)
        ) store_data ON eqd.dms_master_master_id = store_data.store_id
    WHERE  {% condition encoder_id %
```