view: int_prod_vw_restrictions_release_substore {
  sql_table_name: intelligence.dbt_prod.restrictions_release_substore ;;

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


  dimension: list_aggregate_restrictions {
    label: "Restrictions by Substore (List)"
    group_label: "Restrictions"
    type: string
    sql: ${TABLE}.list_aggregate_restrictions ;;
    html:
    {% assign countries = value | split: ";" %}
    {% unless countries.size == 0 %}

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

      <ul>
      {% for country in countries %}
      <li>{{country}}</li>
      {% endfor %}
      </ul>
      </details>

    {% endunless %}
    ;;
  }
}