view: dt_restrictions_label_store {
  sql_table_name: INTELLIGENCE.DBT_PROD.RESTRICTIONS_LABEL_STORE ;;
#  derived_table: {
#    sql:WITH label_store_restrictions AS (SELECT
#    vw.vendor_id,
#    cmm.customer_name,
#    dt.name
#FROM intelligence.dbt_prod.active_vendor_contracts vw
#INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_dms_master_restriction vdmr ON vw.vendor_contract_id = vdmr.vendor_contract_id
#INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master cmm ON cmm.customer_master_master_id = vdmr.customer_master_master_id
#INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_type dt ON dt.id = vdmr.distribution_type_id
#ORDER BY 1,2,3)
#
#SELECT
#    vendor_id,
#    name AS distribution_type,
#    LISTAGG(DISTINCT lsr.customer_name, ', ') WITHIN GROUP (ORDER BY lsr.customer_name) AS list_aggregate_restrictions
#FROM label_store_restrictions lsr
#GROUP BY 1,2
#ORDER BY 1,2;;
#  }

dimension: vendor_id {
  type: number
  hidden: yes
  sql: ${TABLE}.vendor_id ;;
}

dimension: list_aggregate_restrictions{
  type: string
  label: "Restrictions by Store (List)"
  description: "Filter by Distribution Type to see specific restrictions"
  sql: ${TABLE}.list_aggregate_restrictions ;;
  html:
  {% assign stores = value | split: "," %}
  {% unless stores.size == 0 %}

  <details>
  <summary>Detail ({{stores.size}})</summary>

  <ul>
  {% for store in stores %}
  <li>{{store}}</li>
  {% endfor %}
  </ul>
  </details>

  {% endunless %}
  ;;
}

  dimension: distribution_type {
    label: "Distribution Type"
    type: string
    sql: ${TABLE}.distribution_type ;;
  }

 }